Rolling Sum

[Bargs]

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?

 

[Robert Mika]

Excel Workbook
	A	B	C	D	E	F	G	H
1	Current 6	Week7	Week6	Week5	Week4	Week3	Week2	Week1
2	14580	114	127	110	114	120	103	127
3	Previous 6	101	124	103	101	129	103	124
4	14606	111	115	103	111	115	101	115
5		122	117	121	122	113	116	117
6		116	115	121	116	125	123	115
7		113	109	118	113	120	116	109
8		113	116	126	113	121	104	116
9		126	123	116	126	112	121	123
10		103	118	107	103	124	105	118
11		112	105	113	112	127	124	105
12		101	102	127	101	111	109	102
13		119	125	114	119	114	122	125
14		104	107	126	104	124	101	107
15		106	109	109	106	122	129	109
16		129	117	129	129	124	117	117
17		103	107	118	103	110	110	107
18		111	110	121	111	106	123	110
19		127	124	114	127	104	129	124
20		115	104	124	115	104	126	104
21		123	122	122	123	130	128	122
22		130	129	104	130	121	125	129
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?

 

[Bargs]

Did the trick - thanks!