Forum Discussion
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 ...
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.
If miss initial 3200 figures will be as in your sample
With initial 3200 (in A2) it's like
Thank you and to the other respondents for the replies and the answer. I will check the formula on the internet to understand it..