Calculating Project Completion status using text via sheet summary

Gabe Tarin

Hi all,

I am trying to calculate the overall completion of the project based off of trying to calculate the number of tasks with "Completed" as a status, dividing it by the total number of statuses in the "Status" column. I can't seem to figure out the formula to give me that percent. Here is what I am using; HELP!:

=SUM((COUNTIF(Status:status),"Complete")/ (COUNTIF(Status:status), ISTEXT(@cell)))

Mark Cronk

Hi Gabe,

Try:

COUNTIF(Status:Status,"Complete")/ COUNTIF(Status:Status, ISTEXT(@cell))

Work?

Mark

Gabe Tarin

Yes, Thank you!

Mark Cronk

Excellent. Glad you found a solution. Please accept an answer to close the discussion. Thank you for contributing to the Community.

Mark