Count of Ages
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
|