Rolling Sum

Bargs

New Member
Joined
Aug 9, 2009
Messages
10
I'm attempting to calculate a running total of sales from the current six weeks vs the previous six weeks. I'm assigning each week of the year a column and would like to be able to insert a new column each week when new sales figures come out and have my calculation update with each new column - essentially counting the newest column's data and dropping the previous last column's data - if that makes sense. Any suggestions?
 

Some videos you may like

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

Robert Mika

MrExcel MVP
Joined
Jun 29, 2009
Messages
7,256
Excel Workbook
ABCDEFGH
1Current 6Week7Week6Week5Week4Week3Week2Week1
214580114127110114120103127
3Previous 6101124103101129103124
414606111115103111115101115
5122117121122113116117
6116115121116125123115
7113109118113120116109
8113116126113121104116
9126123116126112121123
10103118107103124105118
11112105113112127124105
12101102127101111109102
13119125114119114122125
14104107126104124101107
15106109109106122129109
16129117129129124117117
17103107118103110110107
18111110121111106123110
19127124114127104129124
20115104124115104126104
21123122122123130128122
22130129104130121125129
ml3





If you add new column after column A so B becomes C , C becomes D and so one, the first formula will always give you 6 current week the secon one 6 previous ones.
Is that what you after?
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,122,564
Messages
5,596,875
Members
414,106
Latest member
Tigretto

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top