Thread: how do I insert a row without the formula changing?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom
 
Posts: n/a
Default how do I insert a row without the formula changing?
Where do you insert the row? On top or below?

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

will always average A2:A13


--

Regards,

Peo Sjoblom

"BertiesMum" wrote in message
...
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?


Reply With QuoteReply With Quote