Updating subtotals
 

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??
--
Barb M..
Minnesota

Updating subtotals
 

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.

"Barb <" wrote:

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??
--
Barb M..
Minnesota

Updating subtotals
 

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.
--
Barb M..
Minnesota


"bpeltzer" wrote:

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.

"Barb <" wrote:

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??
--
Barb M..
Minnesota