Previous Topic Next Topic

COUNTIF (but NOT If..)?

Closed
bobbo - Mar 10, 2010 at 12:45 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 10, 2010 at 01:07 PM
Hello,
How do I make Excel not count a cell if it contains a specific value?

Thanks,
Bobbo
Related:

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Mar 10, 2010 at 01:07 PM
If you want to count all cells including blank and only leave out those cells where value is 3 then
=COUNTIF(A:A,"<> 3")

If you want to count all cells excluding blanks and also leave out those cells where value is 3 then

=COUNTIF(A:A,"<> 3") -COUNTBLANK(A:A)
3