thanks for the reply, unfortunatly it don't seem to do the trick. What the
column (containing 5.4, 5.3 etc) is refering to is age, I need to count how
many are 5 (ie how many 5 occurs). how many are 4 etc. Is SUMProduct not
multiplying them?
thanks again for the suggestion, if you've any more ideas I'd appreciate
them.
gR
"Ardus Petus" wrote in message
...
=SUMPRODUCT(CompDb1:C2:C96=4)*(CompDb1:C2:C96<5)
HTH
--
AP
"gerryR" a écrit dans le message de news:
...
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