| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Subtotals: Nested subtotals below higher subtotal | Excel Discussion (Misc queries) | |||
| Subtotals adding a description next to the subtotals | Excel Worksheet Functions | |||
| How do I copy an outline w/ subtotals & paste just the subtotals | Excel Discussion (Misc queries) | |||
| Problem with nested subtotals, placing secondary subtotals BELOW . | Excel Discussion (Misc queries) | |||
| why are nested subtotals coming out below outer subtotals? | Excel Worksheet Functions | |||
Linear Mode
