adding rows without changing the range

[ddean]

Hi,

I have a spreadsheet with the top two rows frozen.

I have a average function on the top row: =AVERAGE(C$3:C$12) The idea is to return the average of the top ten rows below the frozen rows.

I want to insert a row with more data and then have the average of what is now the top ten rows.

When I insert a row with more data, the formula now becomes : =AVERAGE(C$4:C$13)

Is there a way to insert the row and not change the range on the function?

Thanks in advance!!

 

[gaz_chops]

Welcome to the forum.

Try

=AVERAGE(OFFSET(C2,1,,10))

 

[ddean]

Thanks for the Welcome and the speedy response. You solved my problem!!!

 

[gaz_chops]

You're welcome thanks for the feedback.