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

--
HTH

Bob Phillips

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

"jimbob" wrote in
message ...

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


--
jimbob
------------------------------------------------------------------------
jimbob's Profile:
http://www.excelforum.com/member.php...o&userid=29107
View this thread: http://www.excelforum.com/showthread...hreadid=558194