Forum Discussion

keurisandassoc's avatar
keurisandassoc
Copper Contributor
Jul 22, 2020

Running total across multiple columns

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 ...
Formulas and Functions
NikolinoDE's avatar
NikolinoDE
Platinum Contributor
Jul 22, 2020
An image or file would be beneficial to better understand what is wanted.

Nikolino
I know I don't know anything (Socrates)
keurisandassoc's avatar
keurisandassoc
Copper Contributor
Jul 22, 2020

NikolinoDE

 

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's avatar
      keurisandassoc
      Copper Contributor
      Jul 23, 2020

      SergeiBaklan 

       

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

    • keurisandassoc's avatar
      keurisandassoc
      Copper Contributor
      Jul 22, 2020

      NikolinoDE 

       

      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.

       

       

      • NikolinoDE's avatar
        NikolinoDE
        Platinum Contributor
        Jul 22, 2020
        is column H, column C?

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

Resources