Formula to calculate % Complete based on amount of completed tasks vs total tasks

Jmalthouse

Hello Everyone,

For a new project I am working on, i'd like to use a formula that calculates the % complete of a project based on the total amount of tasks, and the tasked marked as complete in the status column.

In my sheet summary, I have a COUNT formula that has totaled all tasks, and all tasks marked as complete but I am not sure of the next step. Any help would be much appreciated!!

Thank you!

Paul Newcome

The % Complete would be the completed tasks divided by the total tasks.