Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint-registration/
In this video, I explain my preferred method for to create running totals in an Excel Table, and also learn how to make those totals conditional on specific criteria.

This method uses structured references to create the running range reference. It's best to avoid using regular range references with Excel Tables because the formulas do not copy down properly when new rows are added to the table.

You can download the Excel file I use in the video on the accompanying blog post:
https://www.excelcampus.com/functions/running-totals-excel-tables

The method in this video uses the SUM function. In the post linked above, I also share an alternative method that uses the INDEX function within the SUM function to create a reference to the first cell. I explain the pros & cons of each method in the post as well.

Please leave a comment below with any questions or suggestions. Thanks!

Related Videos:
Excel Tables Tutorial: Beginners Guide for Windows & Mac:
https://www.youtube.com/watch?v=fJnJTff4Na8&t=24s
Tips & Shortcuts for Inserting Excel Tables:
https://www.youtube.com/watch?v=UpF0BkC6Uls&t=15s

#MsExcel #ExcelCampus
00:00 Introduction
00:41 Creating References
01:32 Running Total
03:10 Using Structured References
05:30 Closing