Hi,

Each week I manually change the following formula by adding an additional cell to the range: 

=AVERAGE(J10:J28)

At the moment I am changing the formula manually to: 

=AVERAGE(J10:J29)

next week I will change it to:

=AVERAGE(J10:J30)

and so on……

is there a way to do this without having to manually do this?

Thank you for your interest.

​Hi, Each week I manually change the following formula by adding an additional cell to the range:  =AVERAGE(J10:J28) At the moment I am changing the formula manually to:  =AVERAGE(J10:J29) next week I will change it to: =AVERAGE(J10:J30) and so on…… is there a way to do this without having to manually do this? Thank you for your interest.    Read More

​