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?

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

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

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.

"bernard liengme" wrote:

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

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

Hi

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

Regards

Roger Govier


BertiesMum wrote:
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.

"bernard liengme" wrote:


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

"BertiesMum" wrote in message
...

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?

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

"Roger Govier" wrote:

Hi

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

Regards

Roger Govier


BertiesMum wrote:
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.

"bernard liengme" wrote:


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

"BertiesMum" wrote in message
...

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?