Forum Discussion
Dynamically change formula when new data is added
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:...
1st option:
=AVERAGE(J10:J1000)
this doesn't work because each cell in J contains a formula
2nd & 3rd options
as above
=AVERAGE(J10:J1000)
this doesn't work because each cell in J contains a formula
2nd & 3rd options
as above
How the data is structured, any logic how formulae in J10:J30 are separated from another formulae in column J?
And where the AVERAGE shall be placed, also in column J or in some other place?