Forum Discussion

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