How to create a running total in a Table

Tip: How to create a running total in a Table

In this video, we’ll look at how to set up a running total in an Excel table.

Setting up a running total in an Excel table is a little tricky because it’s not obvious how to use structured references.

This is because structured references provide a notation for current row, but not for first row in a column.

Let’s explore a few options, starting with formulas based on regular references. 

One common approach is to simply add the row above to the value in the current row…

But this will throw an error because the column header contains text.

Duration 
3:32
Author 

Related shortcuts

Leave a Reply

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