Count IF omitting blank or zeroes

A

Ash

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

Spreadsheet

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

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