Calculation Issues

How to Calculate a Running Total Formula in Excel

Maira Mehtab Sep 22, 2026 869 views

Question details

The user wants to learn how to create a line-by-line running total (cumulative total) in Excel based on amounts entered in another column.

Product: Microsoft Excel / WPS Spreadsheet
Device & OS: not provided
Scenario: Tracking cumulative totals sequentially, such as calculating ongoing sales, taxes, or inventory amounts line-by-line as new data is added.
Observed behavior: The user needs a reliable formula setup that automatically aggregates previous rows' values with the current row's value to display an accurate running sum.

Before you start

Ensure your dataset is organized in columns with a clear header row (e.g., Row 1) and that the numbers you want to calculate are formatted as numeric values rather than text.

Solution 1Recommended

Calculate Running Total Using the SUM Function with Mixed References

The most robust method to calculate a cumulative total is by using the SUM function with a mixed cell reference, which anchors the starting point of your data.

By locking the row number of the first cell in your range, the formula expands dynamically as you copy it down the column, ensuring it always sums from the very first data point to the current row.

Select the target cell

Click on the cell where you want the first running total to appear (for example, cell G2, adjacent to your first data point in E2).

Enter the SUM formula

Type the formula =SUM(E$2:E2) into the formula bar. Replace 'E' with the column letter containing your target numbers, and '2' with your starting row.

Apply the calculation

Press Enter to calculate the first total. The result should match the value of the adjacent cell in that single row.

Fill the formula down

Click the cell containing the formula, hover over the square fill handle at the bottom-right corner, and drag it down the column to apply the running total to the remaining rows.

Understanding the Mixed Reference: The '$' symbol in 'E$2' locks the starting row. As you drag the formula down to the next row, it becomes '=SUM(E$2:E3)', expanding the range automatically.

Solution 2

Calculate Running Total Using Simple Addition

You can also create a running total by adding the current row's value to the previous row's running total cell.

Manage Data Easily

Calculate Running Totals Seamlessly in WPS Spreadsheet

WPS Spreadsheet fully supports standard Excel formulas like SUM and simple arithmetic operations, making it incredibly easy to track running totals for sales, expenses, and inventory without a steep learning curve.

1. Open your data file: Launch WPS Spreadsheet and open the workbook containing your numerical data.
2. Select the formula cell: Click the cell next to your first data point where the cumulative total should begin.
3. Input the SUM formula: Type =SUM(E$2:E2) into the cell, adjusting the column letter and row number to match your dataset, and press Enter.
4. Drag to fill: Hover over the bottom-right corner of the cell and drag the fill handle down to calculate the running total for all subsequent rows.

100% compatible with Microsoft Excel formulas, functions, and formattingCross-platform support for Windows, Mac, Linux, iOS, and AndroidLightweight installation with fast calculation performance for large datasetsFree built-in templates for budget tracking and financial management

microsoft office alternative - wps office

Frequently Asked Questions

Why is my running total formula showing as text instead of calculating a result?

If your formula appears as raw text (e.g., you literally see '=SUM(E$2:E2)' in the cell), the cell's format is likely set to 'Text'. To fix this, right-click the cell, select 'Format Cells', change it to 'General' or 'Number', then double-click inside the cell and press Enter to force it to recalculate.

How do I start a running total from a different row?

You simply adjust the row number in your mixed reference formula. For example, if your numerical data starts in row 5 of column C, your starting formula in the total column would be =SUM(C$5:C5).

Will the running total update automatically if I insert a new row in the middle of my data?

If you are using the =SUM(E$2:E2) method and insert a row, the running total will update, but the new row will be blank. You will need to copy the formula from the cell above into the new blank cell, and the subsequent rows will automatically recalculate to include the new value.

Excel & Data Problems