Counting something like 430<x<=440

I

infinite_zero00

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

Bob Phillips

=SUMPRODUCT(--(B5:E29>430),--(B5:E29<=440))

--

HTH

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


"infinite_zero00"
 
Top