Excel Running Sum / Running Total / Cumulative Total

In this Excel tutorial, I will show you how to calculate a running sum (also called a running total or running balance) and a running average in your spreadsheets using simple formulas and autofill with absolute references. You will learn both the quick and detailed methods for setting up these calculations, how to handle common errors, and why absolute references are important for correct results.

Spencer from Mississauga, Ontario (a Platinum Member) asks: I have a simple spreadsheet that tracks invoices for a customer. I added a new column to calculate the running average of all the invoices. Is there a way to write a formula that I can drag down the column, so it automatically adjusts for each row?

Members

There is no extended cut, but here is the file download:

•  File Download - Gold Members

Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today!

Prerequisites

• Excel Beginner 1

Links

• Excel Moving Average
• Access Check Register

Recommended Courses

• Excel Expert Level 5

Learn More!

• FREE Excel Beginner Level 1
• Excel Beginner Level 2 for $1.00
• Excel Forum
• Mailing List Notifications for New Videos

Questions?

Please feel free to post your questions or comments below. Thanks.

Keywords

TechHelp Excel, Running Total, Running Average, Running Sum, Running Balance, Cumulative Total, Cumulative Sum, Cumulative Running Total, AutoSum Cumulative, Cumulative Formula, Daily Totals, Progressive Total, How to Add Totals Down a Column, Sum to Current Row, Add Up As You Go, Accumulated Total, Dynamic Total, Add Previous Rows, How to add up values step by step, Formula to add each row, Totals that build over time, Beginners running total, Adding up rows automatically, Calculate total so far, running total formula, running sum autofill, running average formula, absolute references, excel sum with autofill, cumulative average, rolling total calculation, excel drag formula, ignore formula error, sum with absolute cell, calculate running totals in table, step by step sum formula, average each row cumulatively, autofill running sum, rolling average formula, trigonometry in excel