how do I insert a row without the formula changing?

B

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

Peo Sjoblom

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

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

will always average A2:A13
 
D

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.
 
Top