insert into a table without altering formulas

[fraz627]

I need help on inserting a row into a table without altering the formula
Example
cell A1 shows the sum of H8 to H100
I would like to insert a new row at row 8 without affecting the formula in A1

thanks in advance

 

[6StringJazzer]

In A1

=SUM(INDEX(H:H,8):INDEX(H:H,100))

Will always sum H8:H100 no matter what is inserted (or deleted)