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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
AVERAGE BASED ON 2 CRITERIA
Maybe you just want:
=average(c2:C4) But the average number of days between dates (to me) is just the number of days between dates. You could subtract them and format the cell with the formula as General. You may want to subtract 1 or 2 if you don't want to include the end dates. aj wrote: 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. -- Dave Peterson |
Reply |
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) |