Number of non-zero values in a column

N

Nick Payne

Given a column of numbers, is there a formula to return the number of cells
containing a non-zero value? ie. Cells can be empty, contain zero, or
contain a number.

Nick
 
N

Nick Payne

Thanks. That was almost it. To allow for empty cells, I had to use
=COUNTIF(A1:A100,"<>0")-COUNTBLANK(A1:A100)

Nick
 
Top