How to I calculate percentage progress in sheet summary based on status?

iamje

How to I calculate percentage progress in sheet summary based on status?

Kleerfyre

You would just need to do some nested IF statements. Example below:

=IF(Status@row = "Not Started", "0%", IF(Status@row = "In Progress", "50%", IF(Status@row = "Complete", "100%")))

Edit: I just re-read your post and you wanted it for the Summary Sheet. It would work the same way based on the Status cell you have in your Summary sheet. Just replace the Status@row with the cell in your summary sheet that has the project status.

iamje

@Kleerfyre It didn't work. Attached is the ss of my sheet summary. So my goal is to to get the percentage by status.

I used percentile but seems not correct. Below data are just initial.

Brucey

Maybe try using "0", "0.5" and "1" and then format the column as a percentage ?

Kleerfyre

What are the numbers under the Value, Value 2, Value 3? Are they counts of tasks with the associated Status? From what you are showing to what you are asking, it isn't lining up for me. Please let me know what you are aiming for based on the most recent screen shots.