Calculating a running total in an Excel table is a little tricky, because it's not obvious how to build the formula with structured references. You can easily get the current row with the @ notation, but what about the first row in a column? You might be surprised that you can use INDEX for this.
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.
An easy workaround in this case is to use the SUM function instead. Because SUM automatically treats text as zero.
The Excel INDEX function returns the value at a given position in a range or array. You can use index to retrieve individual values or entire rows and columns. INDEX is often used with the MATCH function, where MATCH locates and feeds a position to...
The Excel SUM function returns the sum of values supplied as multiple arguments. SUM can handle up to 255 individual arguments, which can include numbers, cell references, ranges, arrays, and constants.