Excel Table Total

%3CLINGO-SUB%20id%3D%22lingo-sub-1802548%22%20slang%3D%22en-US%22%3EExcel%20Table%20Total%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1802548%22%20slang%3D%22en-US%22%3E%3CP%3EHi.%20I%20am%20trying%20to%20design%20a%20Table%20for%20how%20much%20I%20spend%20on%20Groceries%20in%20a%20year%2C%20with%20a%20running%20Total%20at%20the%20top%20of%20the%20Table.%20It%20would%20not%20have%20a%20fixed%20number%20of%20rows%20as%20I%20don't%20know%20how%20often%20I%20would%20go%20to%20the%20shops.%20Therefore%20I%20want%20to%20put%20a%20running%20total%20at%20the%20top%20of%20table%20and%20use%20Freeze%20Panes%20to%20keep%20it%20visible.%3C%2FP%3E%3CP%3EThen%20as%20the%20weeks%20go%20by%20and%20more%20items%20are%20added%20to%20the%20bottom%20of%20the%20table%20the%20total%20is%20always%20visible%20at%20the%20top.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1802548%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Etraining%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hi. I am trying to design a Table for how much I spend on Groceries in a year, with a running Total at the top of the Table. It would not have a fixed number of rows as I don't know how often I would go to the shops. Therefore I want to put a running total at the top of table and use Freeze Panes to keep it visible.

Then as the weeks go by and more items are added to the bottom of the table the total is always visible at the top.

2 Replies

@John_McClean Perhaps like attached. The structured table expands automatically and the SUM function at the top is linked to the entire Amount column of the table.

 

 

 

@John_McClean 

Why create something new if it already exists!

here are some examples from Microsoft.

 

see files and Link

Budgets

https://templates.office.com/en-us/budgets?omkt=en-US

 

 

I would be happy to know if I could help.

 

Nikolino

I know I don't know anything (Socrates)

 

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.