Formula to calculate tasks based on % complete
I have a list of deliverables with a % complete column and I want to calculate the total number of:
completed (at 100%)
in progress (between 1% and 99%)
not started (0%)
I am using the following formula for completed and it is giving me 0 results when I know i have 4 completed
=COUNTIF([% Complete]2:[% Complete]56, "100%")
Any toughs on what I am doing wrong?
Help Article Resources
Check out the Formula Handbook template!