i-nth logo

Table total row

Table total row
7 June 2014

The Table feature of Excel remains one of my favorites. This post explores one very specific aspect of the feature, the total row.

Once the data is stored in a table, we can use the table's name in our formulas. Since tables auto-expand to include new rows, new transactions are automatically included in our formulas. This auto-expansion property helps us build more reliable workbooks.

Another special property is the total row. The total row can be toggled on, or off, at any time to show, or hide, table totals. There are a few interesting points to note about the total row, so, let's dig into the details.