how do I insert a row without the formula changing?

[BertiesMum]

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?

[Peo Sjoblom]

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?

[David McRitchie]

You can use OFFSET from $A$1
or you could write your formula so that the address is within double quotes.

If that does not help or get you started, ...
What is the formula(s) that is not change. Examples of what you want,
what you tried, and what you got are always helpful.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"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?