FOLLOW

CONTACT

ADDRESS

Pleasant Grove, UT

©2017 by Office Newb

UdemyNewYearPromo.jpg
PaparazziAd-01.jpg

Microsoft Excel Running Total with SUM and SUMIF Functions

September 6, 2019

(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

 

 

Please reload

Recent Posts

Please reload

Archive

Please reload

Tags

Please reload