Recent Posts

Archive

Tags

Microsoft Excel Running Total with SUM and SUMIF Functions


(Watch the video for a demonstration)

The Microsoft Excel function, SUM, is the most used function in all of Excel. We typically use the SUM function at the basic level. But, with a little bit of cell reference magic, we can use the SUM function to create a Running Total.

SUM Function

By using a mix of Absolute ($C$2) and Relative (C2) cell references Excel can create a Running Total. In this case the SUM range should always start in cell $C$2. Then, as the formula is dragged down for each record, the top reference stays while the bottom reference will update to the next row.

Download the exercise file to practice: CustomerOrders-02.xlsx

Completed Exercise file for reference: CustomerOrders