% Formula

Elaine Mullis

Hello,

I am trying to calculate the % complete within the "Status" column. I have Task labeled "In progress" "Not Started" "Complete" and "N/A". I have Sum formulas set up to tell me how many are complete etc but am looking for a percentage. Any advice

Screen Shot 2021-12-14 at 2.58.32 PM.png

?

Paul Newcome

To get a percentage you need to divide the "actual" number by the "total" number.

=COUNTIFS(Status:Status, @cell = "Complete") / COUNT(Status:Status)