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