Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Re-usable spreadsheet (or "when you don't know in advance the number of rows")

Hi,

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

= AVERAGE(A1:A5)

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

1) moved down,

2) updated, so that it would compute the average of A1:A15.

Is there a way to simply do that?

Thanks.