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
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 10, 2010 at 01:07 PM
Related:
- Countif but not if
- الدالة countif بالفرنسية - Guide
- How to count names in Excel: formula, using COUNTIF - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Mar 10, 2010 at 01:07 PM
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)
=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)
