Excel Office

Excel How Tos, Tutorials, Tips & Tricks, Shortcuts

Calculate running total in Excel

This tutorial shows how to Calculate running total in Excel using the example below;

Formula

=SUM($A$1:A1)

Explanation

To calculate a running total, you can use the SUM formula with a mixed reference that creates an expanding range. In the example shown, the formula in cell D6 is:

=SUM($C$6:C6)

When this formula is copied down the column, it correctly reports a running total on each row.

Worked Example:   Sum race time splits in Excel

How this formula works

This formula uses what is called a “mixed reference” to create an “expanding range”. A mixed reference is a reference that includes both absolute and relative parts.

In this case, the SUM formula refers to the range C6:C6. However, the first reference to C6 (on the left of the colon) is absolute and is entered $C$6. This “locks” the reference so that it won’t change when copied.

Worked Example:   If cell begins with x, y, or z in Excel

On the right of the colon, the reference is relative, and appears as C6. This reference will change as the the formula is copied down the column.

Worked Example:   SUM function: Description, Usage, Syntax, Examples and Explanation

The result is a range that expands by one row each time it is copied down:

=SUM($C$6:C6) // formula in D6
=SUM($C$6:C7) // formula in D7
=SUM($C$6:C8) // formula in D8

Leave a Reply

Your email address will not be published. Required fields are marked *