How do I count cells with non zero values?

G

Guest

I want to tally the number of cells in a column that have non zero values.
The cout function seem to insist on counting zeros. THe bulk data has plus
and minus values. I can separate them but I have to show a true or false or
zero rahter than blank (I would prefer blank). So how can I tally the entries
in each column with out counting zeros?
 
A

Alan

Assuming the values are all numeric, ie no text values, try
=COUNTIF(A1:A100,"<>"&0)
Regards,
Alan.
 

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

Counting non-zero cells based on date 2
cells with zero value are shown as blank, not zero 2
How to calculate the number of non-zero cells in range? 6
average of non contigous data to also exclude zeros 14
Counting number of cells with non-zero value across multiple worksheets 5
Deleting blank cells globally 8
Count of visible, non-blank cells only? 8
Blank Values in Excel Charts 7

Top