Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |