I’m trying to write a spreadsheet that I could re-use easily even when a number of rows change.
One of the cell (say, on row 6) compute the average, of, say, five other cells, using
The thing is that, sometimes, I want to add, say, 10 rows, after the 5th row, because some situation change.
I’d like that cell computing the average to be automatically
updated, so that it would compute the average of A1:A15.
Is there a way to simply do that?