Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting Ages
I have a number of rows of data with ages of individuals.
I'd like to count the number of ages, but not all individually. For example, I'd like to count the total number of 6 - 12 year olds in my column of ages, etc. I've been using =COUNTIF(A:A, 1) and then adding them all together, but I don't want to have to do this for all the numbers from 0 - 86 (my highest number). Thanks so much. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting Ages
=SUM(COUNTIF(A:A,{"=6","12"})*{1,-1})
"Myjogli" wrote: I have a number of rows of data with ages of individuals. I'd like to count the number of ages, but not all individually. For example, I'd like to count the total number of 6 - 12 year olds in my column of ages, etc. I've been using =COUNTIF(A:A, 1) and then adding them all together, but I don't want to have to do this for all the numbers from 0 - 86 (my highest number). Thanks so much. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting Ages
Assume your ages are in the range A1:A20
Enter you age intervals in a range of cells like this: ......C.....D 1...6.....12 2...13...25 3...26...40 Then enter this formula in E1 and copy down as needed: =COUNTIF(A$1:A$20,"="&C1)-COUNTIF(A$1:A$20,""&D1) -- Biff Microsoft Excel MVP "Myjogli" wrote in message ... I have a number of rows of data with ages of individuals. I'd like to count the number of ages, but not all individually. For example, I'd like to count the total number of 6 - 12 year olds in my column of ages, etc. I've been using =COUNTIF(A:A, 1) and then adding them all together, but I don't want to have to do this for all the numbers from 0 - 86 (my highest number). Thanks so much. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating ages | Excel Discussion (Misc queries) | |||
calculating ages | Excel Worksheet Functions | |||
dates into ages | Excel Worksheet Functions | |||
Dates/ Ages | Excel Worksheet Functions | |||
Calculating Ages from Birthdates | Excel Discussion (Misc queries) |