How to Calculate Running Total in Excel - Practical Guide

Learn to create running totals in Excel—a cumulative sum that increases with each row. Running totals are essential for tracking inventory, sales progression, or financial balances over time, providing clear visibility into accumulated values.

Why This Matters

Running totals help analyze trends and track cumulative progress in financial reports, sales dashboards, and operational metrics. This skill is vital for professionals in accounting, finance, and business analysis.

Prerequisites

•Basic understanding of Excel spreadsheets and cell references
•Familiarity with the SUM function and absolute/relative references

Step-by-Step Instructions

Set up your data

Organize your data with values in column B (e.g., B2:B10). Leave column C empty for running totals. Ensure headers are in row 1.

Enter the first formula

Click cell C2 and enter =B2 to initialize the first running total value equal to the first data entry.

Create the cumulative formula

Click cell C3 and enter =C2+B3 to add the current row's value to the previous running total.

Copy the formula down

Select C3, copy (Ctrl+C), then select the range C4:C10 and paste (Ctrl+V) to extend the running total to all rows.

Verify your results

Check that each cell in column C shows the cumulative sum up to that row. The last value should equal the sum of all data.

Alternative Methods

Using absolute reference method

In C2, enter =SUM($B$2:B2) and copy down. The absolute reference ($B$2) stays fixed while the relative reference (B2) expands, creating a running total automatically.

Using SUBTOTAL function

For filtered data, use =SUBTOTAL(109,$B$2:B2) to calculate running totals while excluding hidden rows in filtered datasets.

Tips & Tricks

✓Use the SUM($B$2:B2) method—it's cleaner and easier to copy across large datasets without errors.
✓Format running total cells as currency or numbers to match your data context for better readability.
✓Add a header like 'Running Total' or 'Cumulative Sum' in column C for clarity.

Pro Tips

★Combine running totals with conditional formatting to highlight when cumulative values exceed thresholds.
★Use the absolute reference method (=SUM($B$2:B2)) for dynamic running totals—it automatically adjusts if data is inserted.
★Create a pivot table alternative for large datasets to calculate running totals more efficiently.

Troubleshooting

Running total shows only single values, not cumulative sums

Ensure you're using =C2+B3 in C3 (not =B3 alone) to add the current value to the previous total. Check that formulas increase properly down the column.

Formula copied down shows errors or unexpected results

Verify cell references are correct and use the SUM($B$2:Bn) method instead, which prevents reference shifting errors.

Running total doesn't match expected final sum

Check for text values disguised as numbers in your data column. Use Data > Text to Columns to convert, or verify all cells are formatted as numbers.

Related Excel Formulas

SUM SUMIF SUBTOTAL CUMSUM

Frequently Asked Questions

What's the difference between =C2+B3 and =SUM($B$2:B3) methods?

Both create running totals, but =SUM($B$2:B3) is more robust because it uses absolute/relative references that automatically expand correctly when copied. The =C2+B3 method depends on manual setup but is simpler for beginners.

Can I create a running total if my data isn't sorted?

Yes, running totals work with unsorted data. However, for meaningful analysis (like cumulative sales over time), your data should be sorted chronologically or logically first.

How do I reset a running total in the middle of my data?

Insert a new row where you want to reset, then restart with =value in the next cell. Alternatively, use conditional formulas with IF statements to reset based on a criteria column.

Does a running total update automatically when I change source values?

Yes, running totals update instantly when you modify any source value in column B because the formulas reference those cells dynamically.