Thread: Count IF omitting blank or zeroes
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Domenic
 
Posts: n/a
Default 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.
Reply With QuoteReply With Quote