"Peo Sjoblom" wrote...
That won't work, using INDIRECT is the only way when it comes to
inserting rows/columns
....

Don't make overly broad assertions. Try to fubar

=AVERAGE(INDEX($1:$65536,1,1):INDEX($1:$65536,10,1 ))

with row insertion/deletion.