Count rows by % Completed?

dinalu

Is there a way to count rows by % completed.  For example, how many items are greater than 50% completed?  I'm getting UNPARSEALBE

I tried a formula like this (but also tried converting % into decimals.... =COUNTIF([% Completel]:[% Complete], >50%)

Note:  also see that the % completed column is part of the Project Properties. 

 

Brian W

It should work if you use this formula:

=COUNTIF([% Complete]:[% Complete], >0.5)

(I noticed you have a typo in your original formula, which could possibly be contributing to the unparseable error.)