Updating subtotals

[Guest]

My spreadsheet is set up with subtotals and when I insert a row directly
above the subtotal the formula does not update to include new row (although
the subtotaling outline does move down).

The Automatic calculation is set in tools/options.

I saw suggestions for changing totals to include new rows.
=sum(a1:index(a:a,row()-1))
which works but is impractical for subtotals throughout a sheet.
Suggestions??

 

[Guest]

Leave a blank row between your data and the subtotal row. Ensure that your
subtotal formulas include the blank row. To add rows, insert above the blank
row. The range included in the subtotal formula should update properly.

 

[Guest]

Thanks, I had thought of that but wanted the sheet as compact as possible.
Made the added rows narrow so it's not too much longer.