Home

Formula Help

%3CLINGO-SUB%20id%3D%22lingo-sub-659922%22%20slang%3D%22en-US%22%3EFormula%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-659922%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20running%20total%20in%20column%20H%20that%20I%20would%20like%20to%20act%20as%20a%20separate%20account%20balance%20for%20each%20of%20the%20names%20in%20Column%20E%20(e.g.%20Name%201%20has%20100%2C%20Name%202%20has%20200%2C%20etc.)%20and%20on%20each%20line%20in%20the%20%22Amount%20Paid%22%20(Column%20G)%20it%20subtracts%20the%20amount%20put%20in%20Column%20G%20from%20their%20individual%20amount(s)%20in%20column%20H.%20Sorry%20if%20this%20is%20confusing%2C%20you%20can%20send%20me%20a%20private%20message%20and%20I'll%20be%20as%20helpful%20as%20possible.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-659922%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
MichaelAyala
New Contributor

I have a running total in column H that I would like to act as a separate account balance for each of the names in Column E (e.g. Name 1 has 100, Name 2 has 200, etc.) and on each line in the "Amount Paid" (Column G) it subtracts the amount put in Column G from their individual amount(s) in column H. Sorry if this is confusing, you can send me a private message and I'll be as helpful as possible.

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