=SUMPRODUCT(--(B5:E29430),--(B5:E29<=440))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"infinite_zero00"
<infinite_zero00.1x0jma_1129496705.0357@excelfor um-nospam.com wrote in
message news:infinite_zero00.1x0jma_1129496705.0357@excelf orum-nospam.com...

I tried =countif(B5:E29, "430<x<=440") but I always get 0, but I can
clearly see that there are values that fit those criteria. Any ideas?


--
infinite_zero00
------------------------------------------------------------------------
infinite_zero00's Profile:
http://www.excelforum.com/member.php...o&userid=28150
View this thread: http://www.excelforum.com/showthread...hreadid=476652