Can I use NOT with COUNTIF?

[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

 

[Per Jessen]

Hi

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

Or maybe better:

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


Hopes this helps.

 

[FSt1]

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

or did i misunderstand.
Regards
FSt1

 

[Per Jessen]

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

 

[PJ]

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

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

 

[PJ]

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

- Show quoted text -

Sorry should be
=COUNTIF(F3:F4,"<>"&"Not Complete")-

 

[T. Valko]

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.

 

[JALunceford]

Excellent!!! This is exactly what I was looking for. Thank You!!

 

[T. Valko]

You're welcome. Thanks for the feedback!