Running Balance Total

%3CLINGO-SUB%20id%3D%22lingo-sub-2629224%22%20slang%3D%22en-US%22%3ERunning%20Balance%20Total%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2629224%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20help%20with%20a%20function.%20I%20am%20building%20a%20basic%20accounts%20calculator.%20I%20have%20attached%20a%20screenshot%20of%20the%20table.%20I%20am%20wanting%20to%20input%20a%20job%20cost%20into%20E5%2C%20and%20have%20it%20added%20to%20the%20running%20total%20of%20M8%20and%20increase%20continuously%20with%20only%201%20input%20in%20E5.%20Overall%2C%20I%20want%20to%20put%20in%20E5%20a%20job%20cost%2C%20have%20it%20allocated%20to%20each%20account%20balance%20and%20gross%20revenue.%20The%20next%20input%20into%20E5%2C%20I%20would%20like%20the%20allocation%20to%20be%20added%20to%20its%20running%20value%20under%20balances.%20For%20example%3A%20if%20I%20put%20in%20%24250%20into%20E5%2C%20I%20want%20%24250%20added%20to%20M8.%20The%20next%20entry%20in%20E5%20is%20%24475.%20I%20want%20that%20added%20to%20the%20%24250%20in%20M8%2C%20to%20equal%20%24725.%20The%203rd%20entry%20in%20E5%20will%20be%20%24350.%20I%20want%20M8%20to%20then%20automatically%20equal%20%241075.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2629224%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2632359%22%20slang%3D%22en-US%22%3ERe%3A%20Running%20Balance%20Total%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2632359%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1124341%22%20target%3D%22_blank%22%3E%40SwankWig%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EIf%20you%20need%20more%20information%20or%20if%20the%20templates%20don't%20help%20you%2C%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3Eplease%20include%20the%20following%20info%20to%20help%20others%20answer%20your%20question%3A%20%3CSTRONG%3EClick%20on%20the%20Link%3C%2FSTRONG%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fwelcome-to-your-excel-discussion-space%2Fm-p%2F2204395%22%20target%3D%22_blank%22%3EWelcome%20to%20your%20Excel%20discussion%20space!%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETemplates%20%26amp%3B%20Informations%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftemplates.office.com%2Fen-ie%2Fbudget-calculator-tm00000050%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EBudget%20calculator%3C%2FA%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftemplates.office.com%2Fen-us%2Fmoney-in-excel-tm77948210%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EMoney%20in%20Excel%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20understanding%20and%20patience%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I need help with a function. I am building a basic accounts calculator. I have attached a screenshot of the table. I am wanting to input a job cost into E5, and have it added to the running total of M8 and increase continuously with only 1 input in E5. Overall, I want to put in E5 a job cost, have it allocated to each account balance and gross revenue. The next input into E5, I would like the allocation to be added to its running value under balances. For example: if I put in $250 into E5, I want $250 added to M8. The next entry in E5 is $475. I want that added to the $250 in M8, to equal $725. The 3rd entry in E5 will be $350. I want M8 to then automatically equal $1075.

1 Reply

@SwankWig 

If you need more information or if the templates don't help you,

please include the following info to help others answer your question: Click on the Link
Welcome to your Excel discussion space!

 

Templates & Informations:

Budget calculator

Money in Excel

 

Thank you for your understanding and patience

 

Nikolino

I know I don't know anything (Socrates)