How do I get my formula to stay the same

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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