How do I get my formula to stay the same

[BertiesMum]

I have a worksheet to calculate 12 week averages, and every week I need to
add a row, but my formulas automatically change so do not include the new
row. What do I need to do to stop the formula changing everytime I insert a
new row?

 

[bernard liengme]

Tell us the layout of the worksheet: what cells have data, what cell has
average. Then we can be of more help
Bernard

 

[BertiesMum]

Column a rows 7 down are weekly sales figures
The formula in a3 is =sum(a7:a18)/12
but when I insert the current week into a new row 7 the formula changes to
=sum(a8:a19)/12
AS I also need the year to date totals I do not want to delete previous
weeks, and prefer to have the most recent weeks at towards the top of the
sheet.

 

[Roger Govier]

Hi

One way
=SUM(OFFSET(A6,1,0,12,1))/12

Regards

Roger Govier

 

[BertiesMum]

Thanks Roger, that's done the trick.....

Hi

One way
=SUM(OFFSET(A6,1,0,12,1))/12

Regards

Roger Govier