| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif to pur a persons age into selected caragories.
Fantastic and thank you for sparing the time to help.
Ron Coderre wrote: Try something like this: For 18 through 21 =SUM(COUNTIF(A:A,{"<18","<=21"})*{-1,1}) For 22 through 31 =SUM(COUNTIF(A:A,{"<22","<=31"})*{-1,1}) For 32 through 41 =SUM(COUNTIF(A:A,{"<32","<=41"})*{-1,1}) etc. Does that help? *********** Regards, Ron XL2002, WinXP Hi [quoted text clipped - 17 lines] 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
