How do I count cells with non zero values?

R

Ryan

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.
 
Top