Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i calculate a 4 week rolling average
How do i get excel to calculate and display a 4 week rolling average? I have
the dates of each week in column A, the sales data is entered in column B. I am not sure if I need to use Today's date to generate the average or if I can just get Excel to drop the 1st week when I enter a new sales figure. If anyone has an understandable formula it would be most appreciated! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i calculate a 4 week rolling average
You said each row contains a total of sales data for the week, and
resides in column B. Assuming your first entry starts on row 1, to get a 4-week rolling average you could simply use this formula in C4: =SUM(B1:B4)/4 When you copy and paste that to the next row, the cell references will shift, and consider only those 4 weeks of data. Does that do what you need it to do? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I setup a rolling 13 week spreadsheet? | Excel Worksheet Functions | |||
help with 12 week rolling average | Excel Worksheet Functions | |||
Rolling 12 week calculations | Excel Worksheet Functions | |||
Create a rolling 12 week graph | Charts and Charting in Excel | |||
Calculation using rolling 4 week amounts | Excel Discussion (Misc queries) |