How to Show a Running Total on Excel Worksheet

About this tutorial:

Video duration: 2:38
Visit this page for the written instructions.

To see the running total in each row of an Excel table, you can use the SUM function.

The total should include all the amounts from the first cell down to the current row. To lock the starting position for the SUM function, you can use an absolute reference to the starting row.

Then, leave the ending position as a relative reference, so it will adjust automatically, when you copy the formula down the column.

Instructor: Debra Dalgleish, Contextures Inc.
Get Debra’s weekly Excel tips:…

Post Author:

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

Leave a Reply

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