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.