@
@Homeonthecouch
Hi all,
I have a sheet that has data in cells A1-A10 and will continue on through
A11, A12 etc as the weeks go on and data is added.
I want to make a sum of lets say A2-A6 this week, but next week A3-A7 and so
on, like a rolling week data.
Is there a way of doing this simple sum without having to SUM(A2-A6) and
editing it the following week to SUM(A3-A7)?
Any help is appreciated
Andrew
I have a sheet that has data in cells A1-A10 and will continue on through
A11, A12 etc as the weeks go on and data is added.
I want to make a sum of lets say A2-A6 this week, but next week A3-A7 and so
on, like a rolling week data.
Is there a way of doing this simple sum without having to SUM(A2-A6) and
editing it the following week to SUM(A3-A7)?
Any help is appreciated
Andrew