I need to know how many tasks are 100% complete in my project. How do I get a current total of the number of tasks that are 100% complete from my %Complete column?

1 Answer 1


Add a spare number field (Number1 for example) and customize the field with the following formula:

IIf([% complete]=100,1,0)

In the Custom fields dialog under "Calculation for task and group summary rows" select "Sum" in the Rollup drop down.

Turn on the Project Summary task to see a total count of complete tasks.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.