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?