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

L

Linda

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.
 
T

Teethless mama

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top