How To Calculate Running Total Using Cumulative SUM In Excel

We cover how to calculate running totals using the cumulative sum technique in excel. In our example, we have a company’s sales and costs for January to December. We want to calculate the cumulative year to date totals. To do this, we use the SUM function and include absolute references in the first part of the range to ensure that this remains static as we drag the formula across. The second part of the range however, remains dynamic which enables Excel to return cumulative totals.

Subscribe for weekly Excel tutorials, techniques and examples:

Please share this video with others that may find it useful:

Please comment below if you have any feedback or any suggestions for videos you would like us to upload next!

ABOUT US:
The Excel Hub seeks to enhance your Excel and VBA knowledge by providing value-adding tutorials, techniques and examples in order to help you take your spreadsheet and data analysis skills to the next level.

For any enquiries, please contact:

Overview: (0:00)
Calculate Gross Profit Figures: (0:22)
Calculate Running Totals: (0:50)