98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel, how to keep subtotals and total all the time at the botto
Excel, how to keep subtotals and total all the time at the botto
Resolved · Medium Priority · Version 2010
Fri 6 Sep 2013, 15:45Delegate Kuniko said...
Kuniko has attended:
Excel Advanced course
Excel Advanced - Formulas & Functions course
Excel Pivot Tables course
Excel VBA Intro Intermediate course
Excel, how to keep subtotals and total all the time at the botto
Hi,
I want to create a table of data, which I keep updating with new entries with cost.
How do I keep the subtotal and total at the bottom of the data table all the time, even I add a new line between other cost entries and subtotal/total lines?
Looking forward to hearing from you soon.
Best regards,
Kuniko
Mon 9 Sep 2013, 21:41Trainer Gary said...
RE: excel, how to keep subtotals and total all the time at the b
Hi Kuniko
Thanks for getting in touch. Maintaining totals will vary according to the method you are using. If you've used the Subtotals feature in Excel, it will struggle with inserted rows.
If you insert a row in the middle of a table with a regular SUM function, this will work.
Alternatively, use a PivotTable.
I hope this helps, if you provide a little more detail behind your worksheet I can offer more advice.
Kind regards
Gary Fenn
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Mon 9 Sep 2013, 21:41Trainer Gary said...
RE: excel, how to keep subtotals and total all the time at the b
Hi Kuniko
Thanks for getting in touch. Maintaining totals will vary according to the method you are using. If you've used the Subtotals feature in Excel, it will struggle with inserted rows.
If you insert a row in the middle of a table with a regular SUM function, this will work.
Alternatively, use a PivotTable.
I hope this helps, if you provide a little more detail behind your worksheet I can offer more advice.
Kind regards
Gary Fenn
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Mon 16 Sep 2013: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Using Alt in Save Dialog BoxWhen you are saving (or opening) a file, try these; |
