Hi

I need some help, i have a simple formula that sums for example AA40:AG40.
Every week this has to increment across 1 column ie. AB40:AH40 in week 2

Currently i'm adjusting these formulas manually. Is there an easier way to
do this?

Thanks
edul