How to Calculate a Running Total in Microsoft Excel

A running total, also known as a cumulative sum, tracks the progressive summation of values across successive rows in a dataset. Whether calculating month-to-date sales figures, monitoring household expenditure against a monthly budget, or measuring inventory burn rates, running totals give instant visibility into financial trajectory without requiring manual subtotals.

Microsoft Excel offers several reliable methods to compute running totals, ranging from classical expanding range formulas to modern dynamic array functions.

Using the Expanding Range SUM Formula

The expanding range formula is the most widely compatible and universally understood method in Excel, functioning identically across all desktop and online versions.

1. Assume your transaction figures are located in column B, beginning at cell B2.
2. Select cell C2, where the first cumulative value will appear.
3. Enter the following formula:

=SUM($B$2:B2)

4. Press Enter. The formula evaluates cell B2 alone, yielding the initial value.
5. Select cell C2, hover your cursor over the small square in the bottom-right corner (the fill handle) until it turns into a black cross, and double-click or drag it down the column.

The mechanics behind this formula rely on mixed cell referencing. By anchoring the starting coordinate with dollar signs ($B$2), the top of the range remains fixed. Meanwhile, the end coordinate (B2) remains relative. When dragged down to row 10, the formula automatically expands to =SUM($B$2:B10), capturing all preceding rows in the calculation.

Creating Running Totals in Official Excel Tables

When working with dynamic data where new rows are added regularly, formatting your range as an official Excel Table (Ctrl + T) provides automated formula propagation:

1. Click anywhere inside your dataset and press Ctrl + T to convert it into a structured Table.
2. Name your columns clearly (for instance, Amount for values and Cumulative Total for the running sum).
3. In the first row of your calculated column, use the INDEX function to anchor the starting row within the structured table syntax:

=SUM(INDEX([Amount], 1):[@Amount])

4. Press Enter. Excel automatically populates every row in the column. When you append new rows to the bottom of the table, the running total calculates instantly without manual dragging.

Generating Instant Totals with the Quick Analysis Tool

If you need an immediate cumulative sum for a presentation or quick audit without typing syntax manually:

1. Highlight your numeric data column (e.g. B2:B25).
2. Click the small Quick Analysis icon that appears in the lower-right corner of your selection (or press Ctrl + Q).
3. Navigate to the Totals tab along the top of the pop-up window.
4. Scroll across to the right and locate the amber-coloured Running icon displaying a down-arrow (running total by column).
5. Click the icon. Excel instantly writes the corresponding formulas into the adjacent column.

Dynamic Array Running Totals with the SCAN Function

In modern versions of Excel (Excel 365 and Excel 2024), the SCAN lambda helper function allows you to calculate a running total across an entire column using a single spilling formula placed in one cell:

1. Select cell C2 next to your data range (B2:B20).
2. Enter the SCAN formula:

=SCAN(0, B2:B20, LAMBDA(accumulator, value, accumulator + value))

3. Press Enter. The results spill downward automatically across all rows. Because there is only one formula residing in cell C2, workbook file size remains minimal and formula maintenance is significantly streamlined.

Suppressing Totals on Blank Rows and Grouping by Category

When working with templates that contain blank entry rows, wrap your expanding sum in an IF condition to keep unused cells clean:

=IF(B2="","",SUM($B$2:B2))

If you need running totals that reset whenever a category changes (for example, tracking expenditure by department in column A), use the SUMIFS function:

=SUMIFS($C$2:C2, $A$2:A2, A2)

This evaluates matching categories dynamically, accumulating expenses strictly within each department before rolling over to the next.