| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to average values based on time period
I have a table with several columns: two of which are labeled Date and Value.
I want to extract the average from the Value column based on a date criteria. For example, what is the average value for the last week? For the last month? For the last year? Can I do this with DAVG and, if so, what should the criteria be? If not, is there a formula I can use to get this done? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Max Value - based on a time period | Excel Worksheet Functions | |||
| Spreading an amount over a period of time based on predetermined % | Excel Worksheet Functions | |||
| I have a problem with conditional formulas based on a time period | Excel Worksheet Functions | |||
| conditional formulas based on a time period | Excel Worksheet Functions | |||
| average rate of change per given time period between 2 moments in time of a value | Excel Worksheet Functions | |||
Threaded Mode
