View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David G[_2_] David G[_2_] is offline
external usenet poster
 
Posts: 9
Default multiple data ranges for countif

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