how to determine how many numbers are greater than zero in a range
 

How do I write a formula indicating how many times a number is greater than
zero in a given range?

how to determine how many numbers are greater than zero in a range
 

If you want to just count the occurrences and are looking for a formula not
a VBA solution...(you posted in the programming newsgroup)

=COUNTIF($A$2:$A$14,"0")

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Inspector" wrote in message
...
How do I write a formula indicating how many times a number is greater
than
zero in a given range?

how to determine how many numbers are greater than zero in a range
 

Hi Inspector,

Try:
=COUNTIF(A1:A1000,""&0)
where 'A1:A1000' is your range.

Cheers


"Inspector" wrote in message
...
How do I write a formula indicating how many times a number is greater
than
zero in a given range?