=countif(A:A,500,)-countif(A:A,600)
=countif(A:A,600,)-countif(A:A,700)

and so on...

Can also do this as a pivot table. drop your values in column and in data.
Right click in the column field, select Group and Outline, Group, have it
group by increments of 100 starting at 500...


"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