Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
averaging based on several criteria
I need to averge based on several criteria.
In column C I have ages In column M I have words for medication used by a patient In column N I have numbers I'd like to search column C for certain ages and then M for a drug and then average the dose (in column N) for those meeting criteria for both colums C and M i.e. average dose (column N) for people under 70 (column C) on drug x (column M). I'd really appreciate any help. Paul |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Averaging set of data based on the time | Excel Worksheet Functions | |||
HELP: Averaging values if they meet certain criteria | Excel Worksheet Functions | |||
Averaging Columns based on a Text String | New Users to Excel | |||
When Averaging a column, exclude value based on another cell value | Excel Worksheet Functions | |||
Averaging data that meets a criteria | Excel Worksheet Functions |