To create a running total in Excel, enter your amounts in B2:B7, type =SUM($B$2:B2) in C2, and fill the formula down column C. Each row will show the sum of the amounts from the first row through that row, updating automatically when the amounts change.
What a running total shows
A running total, also called a cumulative total, adds values in sequence. If a list contains daily sales, for example, the first result is the first day’s sales, the second result combines the first two days, and each later result includes everything above it. Unlike a single grand total, it shows how a value builds over the rows.
Running totals are useful for tracking sales, expenses, inventory changes, project hours, payments, or progress toward a target. The order of the rows matters: if you sort the source data, the cumulative results follow the new order. Decide whether the total should accumulate by date, transaction order, or another sequence, and sort the data accordingly before interpreting the results.
Make a running total with a basic formula
Suppose column A contains dates and column B contains amounts, with headers in row 1 and the first amount in B2. Use column C for the cumulative result. In C2, enter =SUM($B$2:B2). This adds the first amount. When you fill the formula into C3, Excel changes the ending reference to B3 while keeping the starting reference fixed, so the next result includes B2:B3.
For example, if B2:B7 contains 12, 8, -3, 15, 10, and 4, the results in C2:C7 are 12, 20, 17, 32, 42, and 46. The negative amount reduces the cumulative value; it is included like any other number. The final running total, 46, matches the sum of all six entries.
- Enter the values in one continuous column, such as B2:B7.
- Click the first result cell, C2, and enter
=SUM($B$2:B2). - Press Enter. Select C2 again, then drag the small square at its lower-right corner down the column, or copy C2 and paste into the remaining result cells.
- Check the last result against the total of the source values. You can calculate that separately in an unused cell with
=SUM(B2:B7).
The dollar signs are important. In $B$2, both the column and row are locked, so the start of the sum stays at B2. The second reference, B2, is relative: it becomes B3, B4, and so on as the formula is filled down. If you omit the dollar signs, the starting point shifts too, and the formula will no longer accumulate from the first value.
Fill the formula down efficiently
For a short list, dragging the fill handle is straightforward. For a longer list, select the formula cell and the blank cells beneath it, then use Home > Fill > Down. On Windows, Ctrl+D fills down in a selected range; on Mac, Command+D is the corresponding shortcut in Excel. You can also copy the formula cell and paste it into the selected destination cells. These approaches copy the formula pattern, so Excel adjusts the relative ending reference for each row.
If there is a neighboring column filled continuously, double-clicking the fill handle often fills the formula down to the end of that neighboring data. Check where it stops: gaps in the adjacent column can make Excel stop earlier than expected. For important work, inspect the last few formulas or compare the last cumulative result with a separate sum.
Use a running total in an Excel Table
An Excel Table is helpful when new records will be added regularly because its formatting and calculated-column formulas can extend to new rows. To make one, select the data, choose Insert > Table, confirm the range, and select the option indicating that the table has headers if it does. You can also use Ctrl+T on Windows or Command+T on Mac to open the Create Table dialog.
Assume the table has an Amount column in B and a Running Total column in C, and its first data row is row 2. Enter =SUM($B$2:B2) in the first data cell under Running Total. Excel generally fills the formula through that table column and applies it to rows added to the table. Verify that the formula appears in newly added rows, particularly if calculated-column behavior has been changed or the workbook contains existing inconsistencies.
A table does not change the meaning of a running total: it still accumulates in row order. If new records are entered at the bottom, they extend the total in that order. If records are inserted or sorted, the sequence changes, so the cumulative values may change too. A table’s Total Row is different: it displays a summary such as a grand total, not a cumulative value for every record.
Calculate a separate running total for each category
Sometimes the total should restart for each customer, product, or account. For example, column A might contain a category and column B its amounts. Put the per-category running total in C2, then fill it down. Assuming the data starts in row 2, use =SUMIFS($B$2:B2,$A$2:A2,A2). This adds amounts from the start of the list through the current row, but includes only rows whose category matches the current row’s category.
For example, if the rows are North 10, South 7, North 5, and South 3, the results are 10, 7, 15, and 10. North’s total accumulates to 15 across its two appearances, while South’s accumulates to 10. This formula assumes the category and amount data are in A and B respectively, and that the first record is in row 2. Keep the source rows in the sequence you want each category to follow.
Choose the right approach for dates and filtered data
The basic SUM formula accumulates by row position, not by the date displayed in another column. If dates are out of order, sort the records by date before filling the formula if you want the total to follow chronological order. Be aware that sorting only one column instead of the entire data range can misalign dates and amounts. Select the whole dataset or use a Table sort so each record stays together.
There is also a difference between a row-by-row running total and a cumulative total through a date. If several transactions have the same date, a row-by-row formula can show a different result on each transaction. A date-based total may instead show the same total for every row sharing that date, because it includes all transactions dated on or before that date. Choose based on what the report should communicate.
Filtering a list does not make the basic =SUM($B$2:B2) formula recalculate using only visible rows. It continues to include hidden or filtered-out amounts in its range. If the goal is a cumulative total of visible records only, the calculation needs a different design; consider whether the filter is for display only or whether excluded records should truly be omitted from the calculation. Do not assume that hiding rows removes their values from SUM.
Common errors and how to fix them
- The total repeats or stops changing: Check whether each row’s formula has a different ending reference, such as B2, B3, and B4. If every cell refers to the same fixed range, the formula may have been copied as a value or the ending reference may have been locked.
- The starting point moves: Make sure the first reference is absolute:
$B$2. The complete formula in C2 should be=SUM($B$2:B2). - A value is missing: Check that the source entry is a number rather than text. Numbers stored as text may not be added as expected. Look for leading apostrophes, import issues, or inconsistent formatting, and convert the values to numeric data where appropriate.
- The result is unexpectedly low or high: Confirm that the source range begins on the right row and that no rows were omitted. Check for duplicate transactions, hidden rows, and negative values that reduce the total.
- New records have no formula: If the data is not a Table, fill the formula into the new rows. If it is a Table, check whether the new records are actually inside the table and whether the calculated-column formula extended.
- The formula appears as text: Change the cell’s number format from Text to General, then re-enter the formula. Pressing F2 and Enter can also prompt Excel to evaluate a formula that was entered into a cell formatted as Text.
If results do not update after changing an amount, check the calculation setting under Formulas > Calculation Options and choose Automatic if appropriate. In manual calculation mode, formulas may not recalculate until you request it. Also confirm that the formula bar shows a formula beginning with an equals sign rather than a stored result.
Running total versus a grand total
A grand total adds the entire range once, regardless of row order. With amounts in B2:B7, =SUM(B2:B7) returns 46 for the example above. A running total produces one intermediate result per row and ends at the same overall total, provided it covers all the same numeric entries. Use a grand total for a summary figure; use a running total when the progression itself matters.
For a chart that shows cumulative progress, select the sequence and its running-total results, then insert a line chart using Insert > Insert Line or Area Chart. A chart of the original amounts answers a different question: it shows each individual period’s value, rather than the accumulated amount. Label the axis and series clearly so readers do not mistake cumulative values for individual-period results.
Frequently Asked Questions
What is the simplest Excel running total formula?
With the first amount in B2 and the first result in C2, enter =SUM($B$2:B2) and fill down. The fixed starting reference and changing ending reference create the cumulative sum.
Can I calculate a running total without SUM?
Yes. With amounts in B2:B7 and results in C2:C7, enter =B2 in C2, then enter =C2+B3 in C3 and fill that second formula down. This adds each new amount to the prior result. SUM is often easier to audit because each row explicitly sums the source range from the beginning.
Why does my running total change when I sort?
The basic formula accumulates values in their current row order. Sorting changes that order, so intermediate totals change even though the grand total may stay the same. Sort the complete dataset by the field that should define the sequence.
Does a running total ignore filtered-out rows?
No. The basic SUM formula includes values in its referenced range even when their rows are hidden by a filter. A visible-rows-only calculation requires a different approach; decide whether filtering should affect the calculation or only what is displayed.
Can Excel add a running total automatically when I add rows?
A Table can extend a calculated-column formula to new rows. Format the source data as a Table and check that the running-total formula is present in the added row. A normal range needs the formula filled into each new result row.
Can a running total start over for each customer?
Yes. With categories in A2:A7, amounts in B2:B7, and the first result in C2, use =SUMIFS($B$2:B2,$A$2:A2,A2) and fill down. It accumulates only the amounts matching the current row’s category.
Related
- Excel European Number Format: Decimals and Separators
- Excel Subscript Out of Range: Causes and Fixes
- Excel Engineering Number Format Explained
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel MID String: How to Extract Text by Position in CellsIn Excel, use the MID function to extract a specified number of characters from the middle of a…
- Excel Filter Button Shortcut: Keys, Menus, and FixesIn Excel for Microsoft 365 on Windows, press Ctrl+Shift+L to turn filter buttons on or off for a…
- How to Group the Same Numbers in Excel: Sort and CountTo group identical numbers in Excel, sort the entire data range by the column containing those numbers: select…
- Excel Formula for Quarter From Date: 3 Easy MethodsIf the date is in A2, use =ROUNDUP(MONTH(A2)/3,0) to return its calendar quarter as a number from 1…
- Excel Formula List: Essential Functions With ExamplesAn Excel formula list is a practical reference for choosing the right calculation: use =SUM(B2:B6) to total a…
- Excel Filter Only Show Duplicates: A Practical GuideExcel does not have a built-in AutoFilter command that directly displays only duplicate values, but you can add…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.