Forumla to count the number that fall betwee 13-25 in a column
 

I have a formula to count the children ages by month but now i need to know
how many children are between certain age group. I want to put the age in
group between o-12 , 13-24 and 25-36. I want to put it at the end of the
formula for calculating the children age.

Forumla to count the number that fall betwee 13-25 in a column
 

Do you mean 13-24 months old
or
13-24 years old?
--
Gary''s Student - gsnu200800


"Linda" wrote:

I have a formula to count the children ages by month but now i need to know
how many children are between certain age group. I want to put the age in
group between o-12 , 13-24 and 25-36. I want to put it at the end of the
formula for calculating the children age.

Forumla to count the number that fall betwee 13-25 in a column
 

0 - 12 months:
=SUM(COUNTIF(A:A,{"=0","12"})*{1,-1})

13 - 24 months
=SUM(COUNTIF(A:A,{"=13","24"})*{1,-1})


"Linda" wrote:

I have a formula to count the children ages by month but now i need to know
how many children are between certain age group. I want to put the age in
group between o-12 , 13-24 and 25-36. I want to put it at the end of the
formula for calculating the children age.