Previous Topic Next Topic

COUNTIF (but NOT If..)?

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

Thanks,
Bobbo
Related:

1 response

Réponse 1 / 1
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
10 Mar 2010 à 13:07
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)