| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif to pur a persons age into selected caragories.
Hi
I have been task to find a formula to be able to count peoples ages into select different age groups for a quartely report. The age groups i have to catagories them into is 18-21 , 22- 31, 32-41, 42-51, 52 -61 year olds The example is in column A, but my spreadsheet contains over 126 for each month. Age 16 24 45 50 23 60 Please can you help with a formula to help catorgries the aboe ages into the allocated groups. Your help would be most appreciated. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200706/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I am trying to lookup a persons name in a table. | Excel Worksheet Functions | |||
| caculate a persons age | Excel Worksheet Functions | |||
| what formula do i need to calculate a persons age | Excel Discussion (Misc queries) | |||
| Excel for Blind persons use | Excel Discussion (Misc queries) | |||
| How can I create a field indicating a persons age by using bd inf | Excel Worksheet Functions | |||
Threaded Mode
