Count the number between specific Range of numbers

Hi Excel experts!

I need a formula to count the number between specific Range of numbers.
I have attached the sample work sheet with this.Please just check that.

I have some numbers in Column B
2356
2135
500
1890
3750
311

I have to find
(How many numbers between 1 to 500 in the above column ? Ans =2)
(How many numbers between 501 to 1000 above ? Ans=0)
and more ranges like that.

=COUNTIFS(B:B,">=1",B:B,"<=500")
=COUNTIFS(B:B,">=501",B:B,"<=1000")
=COUNTIFS(B:B,">=1001",B:B,"<=1500")

or you could make it use cells:

=COUNTIFS(B:B,">="&A1,B:B,"<="&A2)


Regards, TMS

You're welcome. Thanks for the rep.

Regards, TMS