Help in Groupings

Hi guys,

I have a table with 2 columns as per table below:

Country Count
-------------------
AUSTRIA--------- 1
BAHAMAS-------- 3
BARBADOS-------- 2
CANARY ISLANDS- 6
COLOMBIA-------- 9
GUATEMALA-------11
LUXEMBOURG----- 15
MACEDONIA------ 6
PAKISTAN-------- 8
RUSSIA----------- 13
TAIWAN---------- 3
KENYA----------- 5
ANDORRA-------- 15
BELGIUM--------- 1
CHILE----------- 3
CYPRUS--------- 6
FINLAND-------- 14

How can I count them by using these groupings 1-5,6-10,11-15? So I will have now a table like this:

Group Count
-------------
1-5----- 6
6-10---- 5
11-15--- 5

Please help.thanks

Hi,

You can use a FREQUENCY array to give you this result.

Using your example above, in the same sheet, enter 5, 10 and 15 into cells I1,I2 and I3.

Select cells J1,J2 and J3, press F2 and type =FREQUENCY($F$1:$F$17,$I$1:$I$3)

Instead of just pressing enter to confirm, hold CTRL & SHIFT and press enter.

Or this...
1--5 =SUMPRODUCT(1*($B$1:$B$18<6))
6--10 =SUMPRODUCT(1*($B$1:$B$18>5);1*($B$1:$B$18<11))
11--15 =SUMPRODUCT(1*($B$1:$B$18>10))