Home

Running balance

%3CLINGO-SUB%20id%3D%22lingo-sub-439591%22%20slang%3D%22en-US%22%3ERunning%20balance%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-439591%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20-%20I%20need%20help%20with%20an%20excel%20formula%20to%20show%20a%20remaining%20balance.%26nbsp%3B%20For%20example%2C%20I%20have%20an%20account%20with%20an%20available%20balance.%26nbsp%3B%20I%20need%20to%20set%20up%20a%20formula%20(in%20say%2C%20column%20O)%20that%20will%20reference%20the%20beginning%20total%20(found%20on%20another%20sheet)%20and%20then%20provide%20a%20continuously%20calculated%20remaining%20balance%20once%20I%20enter%20invoices%20for%20each%20month%20(say%20columns%20C%20thru%20N).%26nbsp%3B%20I've%20tried%20looking%20online%20but%20can't%20seem%20to%20find%20any%20formulas%20that%20work%20for%20my%20situation.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-439591%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-439977%22%20slang%3D%22en-US%22%3ERe%3A%20Running%20balance%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-439977%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F319557%22%20target%3D%22_blank%22%3E%40cdean001%3C%2FA%3E%26nbsp%3B%2C%20what%20about%3C%2FP%3E%0A%3CPRE%3E%3DSUM(anothersheet!%26lt%3Bbalance%26gt%3B%2C%20C10%3AN10)%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-441181%22%20slang%3D%22en-US%22%3ERe%3A%20Running%20balance%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-441181%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%2C%26nbsp%3BI%20tried%20that%20formula%20but%20it%20is%20increasing%20my%20remaining%20balance%20rather%20than%20subtracting%20the%20invoice%20amounts%20from%20it.%26nbsp%3B%20I%20apologize%20if%20my%20previous%20question%20wasn't%20clear%20enough%2C%20I%20need%20each%20invoice%20entry%20to%20subtract%20from%20the%20initial%20amount%20leaving%20me%20with%20a%20remaining%20balance.%26nbsp%3B%20Does%20that%20make%20sense%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-445494%22%20slang%3D%22en-US%22%3ERe%3A%20Running%20balance%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-445494%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F319557%22%20target%3D%22_blank%22%3E%40cdean001%3C%2FA%3E%26nbsp%3B%2C%20when%20it%20could%20be%3C%2FP%3E%0A%3CPRE%3E%3Danothersheet!%26lt%3Bbalance%26gt%3B%20-SUM(%24C%2410%3AN10)%3C%2FPRE%3E%0A%3CP%3EYou%20may%20start%20from%3C%2FP%3E%0A%3CPRE%3E%3Danothersheet!%26lt%3Bbalance%26gt%3B%20-SUM(%24C%2410%3AC%2410)%3C%2FPRE%3E%0A%3CP%3Eand%20drag%20it%20to%20the%20right%20to%20show%20result%20for%20each%20month.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-456058%22%20slang%3D%22en-US%22%3ERe%3A%20Running%20balance%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-456058%22%20slang%3D%22en-US%22%3EWOO%20HOO!!%20That%20worked!%20Thank%20you%20so%20much%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E!%20Total%20life%20saver!%3C%2FLINGO-BODY%3E
cdean001
New Contributor

Hi - I need help with an excel formula to show a remaining balance.  For example, I have an account with an available balance.  I need to set up a formula (in say, column O) that will reference the beginning total (found on another sheet) and then provide a continuously calculated remaining balance once I enter invoices for each month (say columns C thru N).  I've tried looking online but can't seem to find any formulas that work for my situation.

4 Replies

@cdean001 , what about

=SUM(anothersheet!<balance>, C10:N10)

Hi @Sergei Baklan, I tried that formula but it is increasing my remaining balance rather than subtracting the invoice amounts from it.  I apologize if my previous question wasn't clear enough, I need each invoice entry to subtract from the initial amount leaving me with a remaining balance.  Does that make sense?

@cdean001 , when it could be

=anothersheet!<balance> -SUM($C$10:N10)

You may start from

=anothersheet!<balance> -SUM($C$10:C$10)

and drag it to the right to show result for each month. 

 

 

 

 

WOO HOO!! That worked! Thank you so much @Sergei Baklan! Total life saver!
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