Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif function question
I have a list of birth dates in column A. I want to provide a list of age
ranges in a summary next to the column. For example I would like to create a function that would give me the count of birthdates in column A that show the number of listings that are less than 2 years old. Then I would like to show the count of listings that are older than 2 years but less than 10 years. And finally I would like to show the count of listings that are older than 10 years. I would like for the calculation to include the function that would keep the counts current. This way as I keep this data over the next few years, I won't have to update the forumula. I found a few countif threads that touched on portions of this question but I didn't know how to make it work. I'm using 2007. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Question on the countif function and times | Excel Worksheet Functions | |||
countif function question | Excel Worksheet Functions | |||
A question about the Count/CountIf function | Excel Worksheet Functions | |||
CountIf Function Question | Excel Discussion (Misc queries) | |||
Countif/Sumif function question | Excel Worksheet Functions |