Percent Completed in Project Plan Formula

rvaughan32

I am looking for a simple formula that shows percentage completed from my project plan. I have a status column that shows 3 values: Complete, Not Started, and In Queue. I simply want to be able to show the percentage of tasks (156 rows in the plan) completed vs the other two statuses to populate in the top of my sheet. IE 78/156 tasks showing completed in my status column which would show 50% completion. Any help or guidance on starting this formula?

PP Screenshot.png

heyjay

=COUNTIF(Status:Status, "Complete") / 
COUNT(Status:Status)

heyjay

=COUNTIF(Status:Status, "Complete") / 
COUNT(Status:Status)

rvaughan32

Thank you!!