Updating subtotals

  • Thread starter Thread starter Guest
  • Start date Start date
G

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??
 
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.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I subtotal specific / random rows from a spreadsheet? 1
Newbie post - help with Subtotal please! 9
Changing my functions to use subtotals? 6
Calculating subtotals 22
Subtotal Function - add formula to all blank rows 1
Getting Text data using the Data - Subtotal feature 1
SUBTOTAL - TJ 2
Need formula to calculate subtotal before sales tax 4

Back
Top