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

Similar Threads

Count Dates in a range based on Column Header Id without using sum-product 1
To count how many are in a certain age group 10
Rolling 12 month 9
Need to count no. of rows where cell in column A = "value1" AND cellin column B (same row) = "value2 2
Help! IF functions 3
How to count the numbers in a Word document? 0
Need to count cells in Column1 where each cell's row also hasspecified value in Column2 2
Lookup and count all cells that fall between 2 dates 3

Top