How to use a mixed reference to create a running total

Let’s take a look.

With normal totals, you might just sum a range and be done.

TheSUM functionadds together all the values in the range and reports the result.

But what if you want to create a running total?

But another option is to set up one formula that you might copy down the entire table.

That way, you have fewer unique formulas and less chance of making a mistake.

Now we need to convert the first reference in the range to anabsolute reference.

This basic approach is the same for horizontal running totals.

Now the formula can be copied across the table and will show the correct running total.