COUNT
It is close but it adding an addition 1, i.e. the count should be 10 but
gives me 11.
"Ron Coderre" wrote:
OOPs....you wanted 1 inclusive:
=COUNTIF(A1:A100,"=1")
Does that help?
***********
Regards,
Ron
XL2002, WinXP
"Ron Coderre" wrote:
By not posting your formula, you don't give us anything to correct.
Try this:
For a range of numbers in A1:A100
This formula returns the count of cell values greater than 1:
B1: =COUNTIF(A1:A100,"1")
Does that help?
***********
Regards,
Ron
XL2002, WinXP
"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
|