| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average by Multiple Criteria.
How can I try to do an average requiring multiple criteria? For example, I
want to do it by Employee Name and Date Range. So if cells A1:A100 is the Name, B1:B100 is the Date and C1:C100 is the score to be averaged, how can I have it pull an average for John Doe for April 1-15th? Thank you |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| average with 2 criteria | Excel Worksheet Functions | |||
| Average / sumproduct based on multiple criteria | Excel Discussion (Misc queries) | |||
| Average # in total group with multiple criteria? | Excel Worksheet Functions | |||
| Using Multiple Array Criteria - Determine Average Result | Excel Worksheet Functions | |||
| match multiple criteria ina range from multiple criteria multiplet | Excel Worksheet Functions | |||
Threaded Mode
