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:
Thank you!
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!