Google Sheets Column Running Total: Formulas That Work

To calculate a running total in a Google Sheets column, enter =SUM($A$2:A2) in B2 when your numbers are in A2:A, then fill the formula down. Each row adds the values from the first data cell through that row, so the result grows as you move down the sheet.

What a running total does

A running total, also called a cumulative total or running sum, shows the sum of values up to each point in a list. It is useful for tracking an account balance, sales over time, inventory changes, monthly spending, or any sequence where the cumulative amount matters as much as the individual entries.

For example, if column A contains 12, 8, and 5, the running totals are 12, 20, and 25. The first result reflects the first value; the next result includes both the first and second values; the third includes all three. This differs from a single grand total, which appears once and sums the whole range.

In Google Sheets, the key is to make the start of the summing range fixed while letting its end move. The dollar signs in $A$2 lock the start cell. The endpoint, such as A2, changes to A3, A4, and so on when the formula is copied down.

Set up the basic formula

Suppose column A contains transaction amounts, with a header in A1, and you want the cumulative result in column B. Follow these steps:

Put a heading such as Amount in A1 and Running total in B1.
Enter the first amount in A2 and the remaining amounts below it.
With values in A2:A and the first result intended for B2, type =SUM($A$2:A2) in B2.
Press Enter. Select B2 and drag its small blue fill handle down through the rows that need totals. You can also copy B2, select the destination cells in column B, and paste.

Google Sheets adjusts the moving endpoint in each copied formula. In B3, the effective range becomes A2:A3; in B4, it becomes A2:A4. The formula in each row therefore includes the current amount and every earlier amount in the chosen starting range. Check that the first result equals the first amount and that each later result changes by the amount on its row.

Why the dollar sign matters

The formula uses a mixed reference: its starting cell is absolute, while its ending cell is relative. In $A$2:A2, the dollar signs keep the start at A2 when the formula moves. Without them, copying the formula down would shift both ends of the range, and the earlier values could drop out. For example, a formula copied down might add only the current row rather than the entire history.

The endpoint should not be locked. If you used $A$2:$A$2, every copied formula would continue to sum only A2, so the total would never accumulate later entries. The useful pattern is: fixed first cell, changing last cell. You can use the same structure in another column by replacing A with the column containing your values and placing the formula in the adjacent results column.

Worked example with a starting balance

A running total can include a balance that existed before the visible rows begin. Put that starting balance in a separate cell, then add it to each cumulative sum. This keeps the opening amount distinct from the new transactions and makes it easier to check or change.

With transactions in A2:A4, the opening balance in C1, and the first running result in B2, use =SUM($A$2:A2)+$C$1 in B2 and fill it down. If C1 is 100 and the transactions are 12, -8, and 5, the results are 112, 104, and 109. The negative entry reduces the balance; it is still included in the sum just like a positive number.

Keep the starting balance outside the transaction range. If it were also included in A2:A, adding it separately would count it twice. It is also worth choosing clear column labels, such as Opening balance, Transaction, and Balance after transaction, so a later reader can tell what the figures represent.

Blanks, text, and negative values

SUM adds numeric values in the referenced cells and generally ignores text stored in cells. A blank transaction row does not erase the previous cumulative amount: the formula for that row sums the same numeric history, so the displayed running total remains unchanged. This can be useful when a sheet has occasional gaps, though leaving the formula in an empty transaction row may show a repeated total there.

Numbers entered as text can be a source of confusion. A value that looks like 25 but is stored as text may not be included in a sum. If a result seems too low, check for pasted values with leading apostrophes, stray spaces, or inconsistent formats. Select the cells and use Format > Number to choose an appropriate number format; formatting changes how values display, but text that is not numeric may need to be converted or re-entered as a number.

Negative values work normally and subtract from the cumulative total. Dates and times are stored as numeric values in spreadsheets, so including them in a sum can produce a result that is mathematically valid but not meaningful for your task. Keep dates in a separate column from amounts, and make sure the formula range includes only the figures you intend to accumulate.

Keep formulas ready for new rows

A formula filled down through the current data will not necessarily appear automatically in every new row added later. If you expect the list to grow, fill the formula down well past the existing entries or copy it into each newly added row. A practical limit, such as several hundred or a few thousand rows, is easier to inspect than filling an entire column with formulas when the sheet does not need them.

In a shared sheet, you can also reserve column B for the running-total formulas and ask collaborators to enter new transactions only in column A. When someone adds data below the prepared formulas, confirm that the corresponding result cell contains a formula. If rows are inserted within the existing data, inspect nearby formulas afterward, particularly if the sheet has other ranges or references tied to those rows.

Google Sheets may offer to autofill a formula when you enter data next to a pattern, but do not assume that every new row has been calculated. A quick check is to select a recent result cell and look at the formula bar. The range should start at the same first transaction cell and end at that row’s transaction cell.

Sorting, filtering, and visible-row totals

A running total follows the order of the rows. If you sort the transactions, you change that order, and the cumulative results will reflect the new sequence. That may be correct for a date-ordered ledger, but it may not be appropriate if the intended order is based on when entries were received or another fixed sequence. Keep a date or sequence-number column and sort the whole data table together, not just the amount column, to avoid separating values from their related records.

The basic SUM formula includes values in rows hidden by a filter. Filtering changes what is shown, not the underlying transaction history. That behavior is usually desirable for a true cumulative balance: a transaction does not stop affecting the balance merely because a view hides it. If you instead need a subtotal that responds to filtered rows, Google Sheets has the SUBTOTAL function, but its behavior and purpose differ from an ordinary running total. Decide whether the result should represent all transactions or only the currently visible subset before choosing a formula.

For a financial or operational record where row order is meaningful, avoid relying on a temporary sort to define history. Add a stable date or sequence field, and use a consistent sort order. A running total is a calculation over the order currently represented by the rows; it does not independently determine which transaction happened first.

Common problems and quick checks

The total repeats the first value: Check that the endpoint is relative, as in A2, rather than locked as $A$2.
The total resets on each row: Check that the starting reference is fixed as $A$2 rather than shifting down with the formula.
A transaction seems missing: Check whether it is a number or text, and make sure the formula range reaches that row.
The result is displayed as a date: The formula cell may have a date format. Use Format > Number and choose a suitable number format, such as Number or Currency.
New entries have no result: Fill or copy the formula into the corresponding result cells.
Totals change after sorting: The row order changed. Sort all related columns together and confirm the new order is the one you intend.

Currency formatting does not change the arithmetic; it only controls how a numeric result appears. To format results, select the result cells and use Format > Number, then choose Currency or another suitable option. If the total is wrong, inspect the formula references and source data before changing number formats.

Frequently Asked Questions

How do I make a running total in Google Sheets?
Place =SUM($A$2:A2) in B2 when your values begin in A2, then fill the formula down. The fixed start includes the full history, and the relative endpoint advances with each row.

Can I start the running total from a balance I already have?
Yes. Keep the opening balance in a separate cell and add it to the cumulative sum. For example, with transactions starting in A2 and an opening balance in C1, use =SUM($A$2:A2)+$C$1 in B2, then fill down.

Does a running total include blank rows?
A blank amount contributes nothing to SUM, so the cumulative figure stays the same at that row. If you do not want repeated figures beside blank transactions, leave those result cells empty or arrange the sheet so formulas are present only on populated rows.

Will filtering change the running total?
Not with the basic SUM formula. It continues to include values in filtered-out rows. Filtering hides rows from view; it does not remove their values from the cumulative history.

Can I use the same formula in Excel?
Yes. The basic formula structure, such as =SUM($A$2:A2), also works in Excel. The instructions here use Google Sheets in a web browser; menu locations and some other spreadsheet features can differ in Excel.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.