Grouping

  • Thread starter Thread starter Jackie
  • Start date Start date
J

Jackie

I have to come up with a count of numbers which fall into
certain ranges: 0 - 1.0, 1.1-4.0, >4.0. Short of sorting
by that field and manually counting, how can I do this?
Thanks for any help.
 
Jackie,

Assuming that your list of numbers is in A1:A50...

1. Enter 0, 1.1 and 4.0 in B1, B2 and B3
2. Enter this formula in C1
=COUNTIF(A$1:$A$50,">="&B1)-COUNTIF($A$1:$A$50,">="&B2)
3. Copy the formula from C1 and paste int C2 and C3
 
It works! Thanks so much.
-----Original Message-----
Jackie,

Assuming that your list of numbers is in A1:A50...

1. Enter 0, 1.1 and 4.0 in B1, B2 and B3
2. Enter this formula in C1
=COUNTIF(A$1:$A$50,">="&B1)-COUNTIF ($A$1:$A$50,">="&B2)
3. Copy the formula from C1 and paste int C2 and C3

--
Ture Magnusson
Microsoft MVP - Excel
Karlstad, Sweden




.
Click to expand...
 
Back
Top