COUNTIF - Between Two Numbers

[Dave]

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

Thanks,
Dave

 

[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