Number of non-zero values in a column

  • Thread starter Thread starter Nick Payne
  • Start date Start date
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
 
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
Divide by the minimum non-zero number in a range of cells 21
Identifying the # of cells containing data 3
Finding 2nd smallest number in range 9
Counting Zeros in a row until encounter first non-zero value 9
Adding recognised Zeros 5
Deleting rows 1

Back
Top