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.