Running Totals in Excel Tables – The Easy WayVevo Digital
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:
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.