=COUNTIF(A:A,"=5")

and

=COUNTIF(A:A,"=4")-COUNTIF(A:A,"=5")

etc.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"gerryR" wrote in message
...
Hi All

Trying to use countif on a range, say my data is below:

5.4
5.3
5.1
5.1
5
4.9
4.9
4.3
4
3.8

I want to have the following

5+ 5
4-5 4
etc...

for the 1st one its no prob, I have the following countif
=COUNTIF(CompDbl!C2:C96,"=5")

but for the next one and below I need to be able to count if the value is
between 2 values, I tried this but no joy:
=COUNTIF(CompDbl!C2:C96,"=4"&"<=4.99")

I'd appreciate any help anyone can provide, can this even be done using
countif??

thanks
gR