I'm trying to find a way to where I can show completion progress on an excel spreadsheet. Ive got about 50 rows of different projects, and Ive got 6 columns for each row. Each column is used for certain criteria to be completed, and each column has a different face value of a percentage (column A would only be 15% of completion, while B and D might be 20%).



The last column takes the total % of that row and shows the progress. For instance, if row 5 has A: 15%, B: incomplete, C: 60%, I'm trying to get that last column to show 75% completed. I just can't find the correct function. I've tried toying with the IF, but I'm not sure how to get it to use multiple variables to equal a total.

Example of my last column I tried getting to work: =IF(C7="X",+"15%",IF(G7="X",+"10%")) etc... But I just cant get it to register multiple columns for the addition part. instead of showing 25% for completion from c7 and g7, it just shows one. like 15%.

By the way, to mark each cell as completed Im trying to use an X inserted into the cell to register complete.

Any help would be much appreciated, thank you.

Please post a sample sheet showing what you have and expected results - Thx (no pics please)

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

That's because you are doing the OR part of the IF instead of adding the terms. Also, there's no need for the quotation marks. This is what you should use...

=IF(C7="X",15%,0) + IF(G7="X",10%,0) + ...

i.e. IF C7 = X, add 0.15, ELSE add 0 + IF G7 = X, add 0.10, ELSE add 0