Count cells with values >x and <y

J

jimbob

Is there a way to count cells with values say, greater than 0.5 and les
than 1.0? I tried using COUNTIF function but it only allows one set o
criteria
 
B

Bob Phillips

=COUNTIF(A:A,">.5")-COUNTIF(A:A,">=1")

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
S

Sheila D

Have a look at the DCount function. This lets you set the criteria for a
particular field in your database and count records matching that criteria

HTH Sheila
www.c-i-m-s.com
 
J

jimbob

For some reason that is not working. When I use COUNTIF()-COUNTIF(), I
getting numbers that are obviously way off. Could it be becouse the co
with the numbers was calculated on copied down formula
 
B

Bernard Liengme

Maybe there is a rounding problem
Try =SUMPRODUCT(--(ROUND(A5:A105,1)>0.5),--(ROUND(A5:A105,1)<1.0))
Change ranges as needed but do not use A:A
best wishes
 
Top