SOLVED
Home

Excel Sum

%3CLINGO-SUB%20id%3D%22lingo-sub-224847%22%20slang%3D%22en-US%22%3EExcel%20Sum%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-224847%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20all%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20like%20to%20sum%20the%20total%20of%20a%20column%20but%20display%20the%20total%20at%20the%20top%20of%20the%20column%20instead%20of%20the%20bottom%20as%20shown%20in%20the%20picture.%26nbsp%3B%20I%20want%20to%20start%20with%20the%20number%20shown%20in%20the%20top%20cell%20the%20enter%20minus%20amounts%20in%20the%20cells%20below%20it.%20The%20cell%20with%20the%20larger%20number%20is%20only%20to%20display%20the%20totals%20and%20the%20lower%20cells%20is%20where%20i%20can%20enter%20the%20amounts.%20Currently%20using%20the%20auto%20sum%20format.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20is%20appreciated%3C%2FP%3E%3CP%3EThanks%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-224847%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-666944%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Sum%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-666944%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20There%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESimilar%20question%20really%20but%20I%20think%20more%20straightforward%3A%3C%2FP%3E%3CP%3EHow%20do%20you%20simply%20get%20the%20SUM%20row%20to%20show%20at%20the%20top%20of%20the%20sheet%2C%20instead%20of%20at%20the%20bottom%3F%3C%2FP%3E%3CP%3EI'm%20adding%20values%20below%2C%20across%20several%20columns%20and%20need%20to%20see%20total%20for%20each%20as%20I%20go.%20Panes%20already%20frozen%20to%20see%20list%20on%20right%20and%20top%20row%20choices.%3C%2FP%3E%3CP%3EHope%20that%20makes%20sense...!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3CP%3EPenny.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-225150%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Sum%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-225150%22%20slang%3D%22en-US%22%3E%3CP%3EYou%20are%20welcome%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-225130%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Sum%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-225130%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20very%20much.%20Work%20perfectly.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-224884%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Sum%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-224884%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Jack%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20your%20%22blue%22%20990%20is%20in%20B3%20you%20may%20use%20for%20B3%20something%20like%3C%2FP%3E%0A%3CPRE%3E%3D990%2BSUM(B4%3AB100)%3C%2FPRE%3E%0A%3CP%3Eor%20which%20range%20you%20have.%20If%20B3%20is%20variable%2C%20you%20may%20change%20them%20in%20a%20helper%20sheet%20and%20use%3C%2FP%3E%0A%3CPRE%3E%3DSheet2!B3%2BSUM(B4%3AB100)%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
Jack Glass
New Contributor

Hello all

 

I would like to sum the total of a column but display the total at the top of the column instead of the bottom as shown in the picture.  I want to start with the number shown in the top cell the enter minus amounts in the cells below it. The cell with the larger number is only to display the totals and the lower cells is where i can enter the amounts. Currently using the auto sum format.

 

Any help is appreciated

Thanks 

4 Replies
Solution

Hi Jack,

 

If your "blue" 990 is in B3 you may use for B3 something like

=990+SUM(B4:B100)

or which range you have. If B3 is variable, you may change them in a helper sheet and use

=Sheet2!B3+SUM(B4:B100)

Thank you very much. Work perfectly.

You are welcome

Hi There

 

Similar question really but I think more straightforward:

How do you simply get the SUM row to show at the top of the sheet, instead of at the bottom?

I'm adding values below, across several columns and need to see total for each as I go. Panes already frozen to see list on right and top row choices.

Hope that makes sense...!

 

Thank you

Penny.

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies