Glenis,
This is what I did:
Column A1 thru A9
"Ages, 0, 3, 5, 7, 11, 15, 19, 20"
This represents the list of ages of people.
Column B1 thru B9
"# of People, 3, 2, 5, 6, 8, 14, 19, 20"
This represents the number of people with the age in column A.
Columns C1, D1,E1 F1
Formated to text, with "0-5, 6-11, 12-15, 16+"
In Cell C2:
"=SUMIF(A2:A9,"<5",B2:B9)"
In Cell D2:
"=SUM(SUMIF(A2:A9, "<12",B2:B9)-C2)"
In Cell E2:
"=SUM(SUMIF(A2:A9,"<16",B2:B9)-D2-C2)"
In Cell F2:
"=SUMIF(A2:A9,"16",B2:B9)"

Ages # of People 0-5 6-11 12-15 16+
0 3 5 19 14 8
3 2
5 5
7 6
11 8
15 14
19 6
20 2

hth

"Glenis" wrote:

Hi

Can someone help me please
I have a long list of ages ranging between 0 and 20 which I need to separate
into
0-5
6-11
12-15
16+
I have been trying to do it with countif but it isn't coming back to the
total numbers, so don't know where I am going wrong.

Many thanks

Glenis