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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to count the maximum number flanked by zeros 9
NumberFormat for small non-zero numbers? 2
Identifying the # of cells containing data 3
Finding 2nd smallest number in range 9
Count cell except those contain zero 4
Divide by the minimum non-zero number in a range of cells 21
Excel and consecutive number 2
Averaging numbers in a column while excluding blank spaces and zer 4

Top