My Excel Formula Changes When i Enter New Lower Line.. But i dont want it to..

[favre4]

Im some what new to excel and want to take a 4week/4line average of a cell. I want it to always be averaging h10-h13. The problem I'm having is when i insert a new line usually around line 9. My equation changes to h11-h14. Can anybody help me fix this?

 

[Oaktree]

Welcome to the board.

Try the INDIRECT function:

=AVERAGE(INDIRECT("H10:H13"))

 

[favre4]

Two hours and i couldn't figure it out. 2 minutes after posting you already have the solution. Thanks MVP