CountIf NOT equal to 100%

Jennifer Flanagan

How do I create a CountIf function for all cells that DO NOT equal 100% under a percent complete column?

I tried the both of following but they do not work:

=COUNTIF [% Complete]:[% Complete], <> =1)

=COUNTIF [% Complete]:[% Complete], <>1)

L_123

Your second one should have worked, can you share a picture of the column? are there blank values?

EDIT: Mark that, you are missing a parenthesis

=COUNTIF([% Complete]:[% Complete], <>1)

Jennifer Flanagan

thanks @L@123 - it still did not work. I am trying to count all the tasks that are critical (have an exclamation point) and NOT 100% complete. Here is my formula: COUNTIFS(Critical:Critical,="High"), [% Complete]:[% Complete], <>1). I know COUNTIFS(Critical:Critical,="High") is correct b/c it works independently

Jennifer Flanagan

and yes some of Parent task rows are blank

L_123

COUNTIFS(Critical:Critical,"High", [% Complete]:[% Complete], <>1)

you prematurely closed off your formula. Notice how you have 2 close parenthesis ) and only one open (.

the equals sign in ="High" is also extraneous, but it doesn't harm anything.

Jennifer Flanagan

Thank you!! that worked :)

L_123

Np. Glad we got it figured out.