Excel Tables are very useful for organizing and reporting data in a tabular format. Furthermore, you can also add a dynamic row to your table to display aggregate data while still utilizing the Excel Table features, like using the same styling and automatically updating the results. In this guide, we’re going to show you how to add a total row in Excel tables.

How to add a Total Row in Excel Tables

  1. Click on a cell inside your table
  2. Open the Design tab
  3. Enable the Total Row checkbox under the Table Style Options section
  4. Click on a cell on a new row, and use the dropdown list to select and add an aggregation function.

Using the Aggregate Row

Following the steps above and selecting the function is all you need to do for creating a Total Row. The listed functions in this section are essentially variations of the SUBTOTAL function, which allow including or ignoring hidden table rows. The SUBTOTAL function is useful if you use filtering in your table.

Alternatively, you can use a custom formula in the totals row. For this, all you need to do is click on the cell and type in the formula.