You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"JALunceford" wrote in message
...
Excellent!!! This is exactly what I was looking for. Thank You!!

"T. Valko" wrote:

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.

--
Biff
Microsoft Excel MVP


"JALunceford" wrote in message
...
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