Create a Running Total in an Excel Column

If you’re using a pivot table, there are built in features that lets you show a running total, or a percent running total.

runningtotalyears03

If you’re using worksheet formulas, instead of a pivot table, there’s nothing built in that will automatically create a running total for you. Fortunately, with a simple SUM formula, you can calculate the running total in each row, to see how your bank account is doing.

Use the SUM Function

In this example, there are withdrawal and deposit amounts in cells C2:C6. We could use the SUM function to total the amounts in column C, and that would give us the current total.

sumcolumn

Instead, we’ll use the SUM function in each row, to calculate the running total. We’ll be able to see the total after each withdrawal and deposit.

The formula in cell D2 is: =SUM(C$2:C2)

sumrunningtotal01

That $ sign locks the reference to row 2, at the start of the sum, so it doesn’t change when the formula is copied down to cell D6.

The ending cell – C2 – is a relative reference, so the ending point changes for each row. For example, in cell D6, the formula shows C6 as the ending cell for the SUM formula.

sumrunningtotal02

Watch the Video

To see the steps for creating a running total on a worksheet, please watch this short video.

YouTube: How to Show a Running Total on Excel Worksheet

_______________________