COUNT
It is close but it adding an addition 1, i.e. the count should be 10 but
gives me 11.
"Toppers" wrote:
=countif(A1:A100,"0") if numbers can be decimal and less than 1 e.g 0.56
Or
=countif(A1:A100,"=1")
HTH
"Christina Bachman" wrote:
How do I count cells with numbers 1 and greater. My cells are counting the
-. All my cells are showing the - (zero value) but are being counted. Thanks
|