I've done it!!
Because we haven't got = on the second countif it isn't picking up the 5 so
I have changed it to 6 and so on and it now works.

Many thanks for helping me figure out what I was doing wrong.

Regards

Glenis

"KC" wrote:

Glenis,
try this...

Col-A Col-B
Name Age
name0 0
name1 1
name2 2
name3 3
name4 4
name5 5
name6 6
name7 7
name8 8
name9 9
name10 10
name11 11
name12 12
name13 13
name14 14
name15 15
name16 16
name17 17
name18 18
name19 19
name20 20

0-5 =COUNTIF(B2:B22,"=0")-COUNTIF(B2:B22,"5")
6-11 =COUNTIF(B2:B22,"=6")-COUNTIF(B2:B22,"11")
12-15 =COUNTIF(B2:B22,"=12")-COUNTIF(B2:B22,"15")
16+ =COUNTIF(B2:B22,"=16")


hope this helps.
-kc
*Click YES if this helps


"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