Grouping

[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.

 

[Ture Magnusson]

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

 

[Jackie]

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




.

 

[Ture Magnusson]

You are welcome, Jackie! I'm happy that I could be of assistance.