Where do you insert the row? On top or below?

=AVERAGE(INDIRECT("A2:A13"))

will always average A2:A13


--

Regards,

Peo Sjoblom

"BertiesMum" <BertiesMum@discussions.microsoft.com> wrote in message
news:3B9CBC6E-704B-49F4-B9BE-4305C51A20C1@microsoft.com...
> I have set up a work book to calculatre 12 week averages, and need to
insert
> a new row each week, but when I do the formulas change. How do I stop
this
> to make the formula take account of the new row?