| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
AVERAGE BASED ON 2 CRITERIA
I have a set of data on the entry and exit dates of a person. I have
calculated the number of days between two dates. I would now like to average the number of days that fall in between two dates. Example: Enter Date Exit Date Number of days 1/12/09 1/13/09 1 1/19/09 1/23/09 4 1/26/09 1/30/09 3 I'd like the aver number of days between 1/12 and 1/19. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| average based on criteria | Excel Worksheet Functions | |||
| need to average based on criteria | Excel Discussion (Misc queries) | |||
| average one column based on criteria from another | Excel Discussion (Misc queries) | |||
| Calculating an average based on 2 and 3 criteria | Excel Worksheet Functions | |||
| caluculate an average based on 2 criteria | Excel Discussion (Misc queries) | |||
Threaded Mode
