I would like to have new column (say column B) where I would like to get cumulative sum from column A.
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.
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.