On Sep 18, 1:12 pm, Mike H wrote:
Try,

=AVERAGE(INDIRECT("A1:A33"))

That will leave out the new A34 after the insertion, though.

tulip, where is the formula? You can use this much INDIRECT("A1:A"
of Mike's formula and then perhaps an OFFSET or ROW function to keep
the bottom number dynamic, too.