COUNTIF (but NOT If..)? [Closed]

Report
-
rizvisa1
Posts
4475
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
January 6, 2016
-
Hello,
How do I make Excel not count a cell if it contains a specific value?

Thanks,
Bobbo

1 reply

Posts
4475
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
January 6, 2016
756
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
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 3881 users have said thank you to us this month