Formula Needed for calculating weekly totals horizontally

[Danny318]

Want to fill across a formula for grabbing the weekly totals (every 8 days) instead of manually typing in cell number 52 times. When I drag across it gives me the next day instead of the next 8th day.
See example week 1-week 4 totals in bold:

1​

2​

3​

4​

5​

6​

7​

Total Wk 1

1​

2​

3​

4​

5​

6​

7​

Total Wk 2

1​

2​

3​

4​

5​

6​

7​

Total wk 3

1​

2​

3​

4​

5​

6​

7​

Total Wk 4

Week 1

Week 2

Week 3

Week 4

Number

34​

33​

33​

44​

33​

55​

33​

265​

44​

33​

44​

33​

44​

33​

22​

253​

44​

33​

44​

33​

44​

33​

22​

253​

44​

33​

44​

33​

44​

33​

22​

253​

265​

253​

33​

33​

Thank you!

 

[Fluff]

How about

+Fluff New.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK
1		1	2	3	4	5	6	7	Total Wk 1	1	2	3	4	5	6	7	Total Wk 2	1	2	3	4	5	6	7	Total wk 3	1	2	3	4	5	6	7	Total Wk 4	Week 1	Week 2	Week 3	Week 4
2	Number	34	33	33	44	33	55	33	265	44	33	44	33	44	33	22	253	44	33	44	33	44	33	22	253	44	33	44	33	44	33	22	253	265	253	253	253
Master

Cell Formulas
Range	Formula
AH2:AK2	AH2	=INDEX($B$2:$AG$2,AGGREGATE(15,6,(COLUMN($B$1:$AG$1)-COLUMN($B$1)+1)/(LEFT($B$1:$AG$1,5)="Total"),COLUMNS($AH1:AH1)))

 

[Danny318]

Perfect Thanks!

 

[Fluff]

You're welcome & thanks for the feedback.