All Excel Tables come with a built-in Total Row feature.
The total row allows you to easily show summary calculations below a table.
There are a couple ways you’re able to display a total row for a table.
There, under Table Style options, you’ll find a checkbox for a Total Row.
Check to display, and uncheck to hide.
Once you display a Total row, you could configure which kind of result you want to see.
When you click into any cell, you’ll see a drop down menu with available options.
Usually, Excel will have already selected a reasonable option.
In this case for example, we see a sum of the Tax column.
However, you might easily switch to average, count, min, max, and so on.
The reason SUBTOTAL is used is because it has the ability to ignore hidden rows.
This allows the calculated summaries to update properly when the table is filtered.
There is also an option to see a larger list of functions.
If you select a function like SUMIF, you’ll see a familiar configuration dialog.
Again, you’ll see the formula in the formula bar, which you could easily edit.
One thing that’s not obvious about the Totals row is that you might add more than one formula.
Likewise, I can add another formula to sum the total column.
