=COUNTIF(A2:A1000,""&B2)-COUNTIF(A2:A1000,""&C2)

B2=401, B3=501 etc
C2=500, C3=600 etc

HTH

"David G" wrote:

I am trying to find the number of times my value falls in a certain range.
the data looks like this:
Clg (Tons)
500.6
486.9
473.4
465.8
469.8
510.1
497.5
538.9
623.5
688.5
671.8
687.3
673.9
690.9
716.5
713.7
704.6
665.8
606.3
599.9
582.3
497.4
498.8
478.8

and my different ranges would be in one hundred increments (i.e. 400-500,
501-600,601-700,etc.)
Any help would be great