How to Create a Cumulative Running Total in Excel?
A running total helps you keep track of cumulative sums in your data. This guide will show you how to set it up easily in Excel.
Formula Genius can generate a draft from a plain-English prompt. Supported formulas can be checked with sample cases; review the coverage on the result.
The formula
"Create a cumulative running total in a column where each row adds to the sum of all rows above it"
=SUM($A$1:A1)This formula calculates the cumulative sum of values in a specified column up to the current row.
Step-by-step breakdown
- The SUM function adds up numbers in a specified range.
- The range starts from the first cell ($A$1) and extends to the current row (A1).
- The dollar sign ($) before A1 makes the reference absolute for the starting point.
- As you drag the formula down, the end of the range (A1) updates to include the current row.
Edge cases & warnings
- If the first cell is empty, the running total will start from zero.
- If any cell in the range contains text, it will be ignored in the sum.
- If you insert a new row above the first row, you may need to adjust the formula.
Examples
"A1=10, A2=20, A3=30"
A1=10, A2=30, A3=60"A1=5, A2=15, A3=10"
A1=5, A2=20, A3=30Frequently asked questions
Can I use this formula for non-contiguous ranges?
No, this formula only works for contiguous ranges.
What if I want to start the running total from a different row?
You can adjust the absolute reference in the formula to start from any row.
Will this formula update automatically if I add more data?
Yes, as long as you drag the formula down to cover the new rows.
Can't find what you need?
Describe a formula in plain English. Formula Genius drafts and explains it, and can check supported formulas on sample cases.