Can I use NOT with COUNTIF?

  • Thread starter Thread starter JALunceford
  • Start date Start date
J

JALunceford

Can I use NOT with COUNTIF?

I have a column with values of "Complete" an "Not Complete". I don't want
to add the "Not Complete" in the count. I've racked my brains for a few
hours now and can't seem to get it right. I figured this would be simple,
but I'm stumped. I'm not sure if this is the right formula to use since NOT
returns TRUE or FALSE. Please help.

Column F
Row 3 Complete
Row 4 Not Complete

=COUNTIF(F3:F4,NOT("Not Complete"))

I'm looking for a result of 1.

Thanks,
Jake
 
Hi

=COUNTIF(F3:F4,<>"Not Complete")

Or maybe better:

=COUNTIF(F3:F4,="Complete")


Hopes this helps.
 
hi
confused. try this and see if it's what you want.....
=COUNTIF(F3:F4,"Complete")

or did i misunderstand.
Regards
FSt1
 
Forget my last post.

=COUNTIF(F3:F4,"Complete")

Or if you want to count entires different from Not Complete you can use
this:

=SUMPRODUCT(--(F3.F4<>"Not Complete"))

Best regards,
Per
 
Can I use NOT with COUNTIF?

I have a column with values of "Complete" an "Not Complete".  I don't want
to add the "Not Complete" in the count.  I've racked my brains for a few
hours now and can't seem to get it right.  I figured this would be simple,
but I'm stumped.  I'm not sure if this is the right formula to use since NOT
returns TRUE or FALSE.  Please help.

              Column F
Row 3     Complete
Row 4     Not Complete

=COUNTIF(F3:F4,NOT("Not Complete"))

I'm looking for a result of 1.

Thanks,
Jake
Click to expand...

Something along the lines of this?
=COUNTIF(E5:E6,"<>"&"Not Complete")
 
Something along the lines of this?
=COUNTIF(E5:E6,"<>"&"Not Complete")- Hide quoted text -

- Show quoted text -
Click to expand...
Sorry should be
=COUNTIF(F3:F4,"<>"&"Not Complete")-
 
Try it like this:

=COUNTIF(F3:F4,"<>Not Complete")

The <> operator means "not equal to".

Note that it will count all cells not equal to Not Complete and this
includes empty/blank cells.
 
Back
Top