Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how do i set up a moving average in Excel
i am trying to set up a 7 day running average and cannot figure out how to do
it? Any help would be greatly appreciated. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how do i set up a moving average in Excel
Hope I understand the Q
You have numbers in A1:A20 and will be adding more In B7 enter =IF(ISNUMBER(A7),AVERAGE(A2:A7),"") Copy down the column This finds the average of the preceding seven numbers in A, provided there is a value next to it best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "p-nut" wrote in message ... i am trying to set up a 7 day running average and cannot figure out how to do it? Any help would be greatly appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Excel ? Formula for moving average | Excel Worksheet Functions | |||
moving text from a word document to excel | New Users to Excel | |||
moving average of figures from separate tables | Excel Discussion (Misc queries) | |||
24hr moving average | Excel Discussion (Misc queries) |