COUNTIF - Between Two Numbers

D

Dave

From one column of numbers, I want to count if the number
falls within a range (say 500 to 1000).

Thanks,
Dave
 
D

Dan E

For 500 < X < 1000:
=COUNTIF(A1:A100,">500")-COUNTIF(A1:A100,">=1000")
OR
=SUMPRODUCT(--(A1:A100>500),--(A1:A100<1000))

For 500 <= X <= 1000
=COUNTIF(A1:A100,">=500")-COUNTIF(A1:A100,">1000")
OR
=SUMPRODUCT(--(A1:A100>=500),--(A1:A100<=1000))

Dan E
 
Top