| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Annualized rolling (moving) average
I am using the following formula to calculate an average of data for a
rolling 365 day period. Column A is the date, column B is Data =((SUMPRODUCT(--($A$1:$A3<$A3),--($A$1:$A3=$A3-365),($B$1:$B3))))/(SUMPRODUCT(--($A$1:$A3<$A3)*--($A$1:$A3=$A3-365))) Is there a simpler way to accomplish this? How can I calculate the standard deviation for the same period? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Moving Weighted Average formula | Excel Discussion (Misc queries) | |||
| How to create a rolling 6 month average? | Excel Discussion (Misc queries) | |||
| rolling average | Excel Worksheet Functions | |||
| Moving Average projection? | Excel Worksheet Functions | |||
| 30 Day Moving Average Ignoring Blank Cells | Excel Worksheet Functions | |||
Threaded Mode
