Number of non-zero values in a column
 

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

Number of non-zero values in a column
 

How about this:

=COUNTIF(A1:A100,"<0")

HTH,
Elkar


"Nick Payne" wrote:

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

Number of non-zero values in a column
 

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

Nick

"Elkar" wrote in message
...
How about this:

=COUNTIF(A1:A100,"<0")

HTH,
Elkar


"Nick Payne" wrote:

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.