Hi,
I would like to have new column (say column B) where I would like to get cumulative sum from column A.
eg:
ColumnA. ColumnB
250,000 250,000
(200,000) 50,000
75,000 125,000
something like cumsum in python.
I need this in the same worksheet where ColumnA is available. The cumulative balance is required to commented through email.
Hi @Chandrasekhar_Dommar,
Assuming your data is in columnA and the result col is ColumnB, you can use column formula =SUM(A,IFERROR(INDIRECT("B" & (ROW()-1)),0) to compute the cumulative sum.
2 Likes