Thread: Count of Ages
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
KC KC is offline
external usenet poster
 
Posts: 94
Default 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