Count IF omitting blank or zeroes
 

I am sure this was posted before. What I want is be able to count cells
that have numbers only excluding zeroes and blank cells.


--
Ash

Count IF omitting blank or zeroes
 

Try...

=COUNT(A2:A100)-COUNTIF(A2:A100,0)

Hope this helps!

In article ,
Ash wrote:

I am sure this was posted before. What I want is be able to count cells
that have numbers only excluding zeroes and blank cells.

Count IF omitting blank or zeroes
 

=COUNTA(range)-COUNTIF(range,"=0")

There's probably a way to do it without any need for a subtraction, but
this does work.


--
Spreadsheet
------------------------------------------------------------------------
Spreadsheet's Profile: http://www.excelforum.com/member.php...o&userid=34730
View this thread: http://www.excelforum.com/showthread...hreadid=556693