How do I count cells with non zero values?
 

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?

How do I count cells with non zero values?
 

Assuming the values are all numeric, ie no text values, try
=COUNTIF(A1:A100,"<"&0)
Regards,
Alan.
"Ryan" wrote in message
...
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?