Running total across multiple columns

%3CLINGO-SUB%20id%3D%22lingo-sub-1537655%22%20slang%3D%22en-US%22%3ERunning%20total%20across%20multiple%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1537655%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20column(Column%20H)%20which%20has%20a%20running%20balance%20going%20down%20the%20sheet.%26nbsp%3B%20%26nbsp%3BThe%20balance%20is%20made%20up%20of%20values%20from%20columns%20F%20and%20G.%26nbsp%3B%20%26nbsp%3Bi.e%26nbsp%3B%20%26nbsp%3Bstarting%20balance%20on%20line%201%20in%20H%20is%203200.%26nbsp%3B%20In%20line%202%20there%20is%20a%20subtraction%20of%20200%20in%20column%20G%20which%20reduces%20the%20balance%20of%20H%20to%203000.%26nbsp%3B%20In%20line%203%20there%20is%20an%20addition%20of%201000%20in%20column%20F%20and%20a%20subtraction%20of%20300%20in%20column%20G%20which%20means%20that%20column%20H%20is%20now%202700.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20is%20possible%20to%20construct%20a%20formula%20which%20incorporates%20this%20process%20as%20the%20column%20H%20cell%20is%20always%20dependent%20on%20the%20value%20of%20the%20column%20H%20cell%20on%20the%20previous%20line%20plus%20the%20addition%20of%20the%20column%20F%20and%20G%20cells%20on%20the%20current%20line.%26nbsp%3B%20%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1537655%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1537759%22%20slang%3D%22de-DE%22%3ESubject%3A%20Running%20total%20across%20multiple%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1537759%22%20slang%3D%22de-DE%22%3EAn%20image%20or%20file%20would%20be%20beneficial%20to%20better%20understand%20what%20is%20wanted.%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20Nikolino%20%3CBR%20%2F%3E%20I%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1537793%22%20slang%3D%22en-US%22%3EBetreff%3A%20Running%20total%20across%20multiple%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1537793%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F722750%22%20target%3D%22_blank%22%3E%40Nikolino%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%20Nikolino.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20attached%20the%20sheet.%26nbsp%3B%20%26nbsp%3BThe%20original%20sheet%20is%20larger%20but%20I%20have%20cropped%20out%20this%20portion%20in%20relation%20to%20the%20issue.%26nbsp%3B%20%26nbsp%3BThe%20current%20values%20in%20Column%20C(original%20column%20H)%20were%20pre-populated%20but%20the%20column%20was%20missing%20the%20original%20entry%20of%20the%203200%20which%20means%20that%20all%20of%20the%20following%20entries%20need%20to%20be%20adjusted%20and%20I%20hoping%20that%20there%20is%20global%20way%20to%20do%20the%20whole%20column%20as%20opposed%20to%20manually%20changing%20each%20entry.%26nbsp%3B%20%26nbsp%3B%20Further%2C%20some%20of%20the%20entries%20in%20column%20C%20are%20clearly%20incorrect%20based%20upon%20the%20pattern.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1537882%22%20slang%3D%22de-DE%22%3ESubject%3A%20Running%20total%20across%20multiple%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1537882%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F735862%22%20target%3D%22_blank%22%3E%40keurisandassoc%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20english%20is%20not%20the%20best%20...%20is%20it%20a%20simple%20subtraction%3F%20see%20example%20in%20file%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1537887%22%20slang%3D%22en-US%22%3EBetreff%3A%20Running%20total%20across%20multiple%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1537887%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F722750%22%20target%3D%22_blank%22%3E%40Nikolino%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20Nikolino%20but%20Column%20A%20is%20going%20to%20add%20to%20the%20total%26nbsp%3B%20in%20column%20h%20and%20column%20b%20is%20going%20to%20subtract%20from%20the%20total%20in%20column%20H.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1537904%22%20slang%3D%22de-DE%22%3ESubject%3A%20Running%20total%20across%20multiple%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1537904%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F735862%22%20target%3D%22_blank%22%3E%40keurisandassoc%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EStill%20don't%20know%20what%20exactly%20is%20required%20...%20I'm%20out%20of%20order%20today%2C%20sry%20...%20Please%20take%20a%20look%20at%20this%20file%2C%20is%20that%20it%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1537939%22%20slang%3D%22de-DE%22%3ESubject%3A%20Running%20total%20across%20multiple%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1537939%22%20slang%3D%22de-DE%22%3Eis%20column%20H%2C%20column%20C%3F%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20in%20the%20TestSheet%20is%20see%20Numbers%20only%20in%20A%2CB%2CC...%20H%20is%20empty.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1538079%22%20slang%3D%22en-US%22%3EBetreff%3A%20Running%20total%20across%20multiple%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1538079%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F735862%22%20target%3D%22_blank%22%3E%40keurisandassoc%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20miss%20initial%203200%20figures%20will%20be%20as%20in%20your%20sample%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20418px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F207093iD44357F0081EA84D%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EWith%20initial%203200%20(in%20A2)%20it's%20like%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20463px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F207094i3119066F4B711A48%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1540010%22%20slang%3D%22en-US%22%3EBetreff%3A%20Running%20total%20across%20multiple%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1540010%22%20slang%3D%22en-US%22%3E%3CP%3E%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%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20and%20to%20the%20other%20respondents%20for%20the%20replies%20and%20the%20answer.%26nbsp%3B%20%26nbsp%3B%20I%20will%20check%20the%20formula%20on%20the%20internet%20to%20understand%20it..%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I have a column(Column H) which has a running balance going down the sheet.   The balance is made up of values from columns F and G.   i.e   starting balance on line 1 in H is 3200.  In line 2 there is a subtraction of 200 in column G which reduces the balance of H to 3000.  In line 3 there is an addition of 1000 in column F and a subtraction of 300 in column G which means that column H is now 2700.

 

It is possible to construct a formula which incorporates this process as the column H cell is always dependent on the value of the column H cell on the previous line plus the addition of the column F and G cells on the current line.   

8 Replies
An image or file would be beneficial to better understand what is wanted.

Nikolino
I know I don't know anything (Socrates)

@Nikolino

 

Hi Nikolino.  

 

I have attached the sheet.   The original sheet is larger but I have cropped out this portion in relation to the issue.   The current values in Column C(original column H) were pre-populated but the column was missing the original entry of the 3200 which means that all of the following entries need to be adjusted and I hoping that there is global way to do the whole column as opposed to manually changing each entry.    Further, some of the entries in column C are clearly incorrect based upon the pattern.

@keurisandassoc 

My english is not the best ... is it a simple subtraction? see example in file

@Nikolino 

 

Thanks Nikolino but Column A is going to add to the total  in column h and column b is going to subtract from the total in column H.

 

 

@keurisandassoc 

 

Still don't know what exactly is required ... I'm out of order today, sry ... please take a look at this file, is that it?

is column H, column C?

in the TestSheet is see Numbers only in A,B,C...H is empty.

@keurisandassoc 

If miss initial 3200 figures will be as in your sample

image.png

With initial 3200 (in A2) it's like

image.png

@Sergei Baklan 

 

Thank you and to the other respondents for the replies and the answer.    I will check the formula on the internet to understand it..