Enter this formula: =SUM($B$2:B2) into a blank cell beside your data, see screenshot:Ģ. To get the cumulative sum for a column data, you can apply the following formulas, please do as this:ġ. This article, I will talk about how to solve it in Excel worksheet.Ĭalculate cumulative sum or running total of a column with formulas How to calculate cumulative sum / running total of a column in Excel?Ī calculate cumulative or running total is used to watch the summation of numbers that is updated every time when a new number is entered to the sequence.