When you are working with a table in Excel you can have the aggregations calculate automatically. How can you create a column sum, average, count or other aggregation?

If you click inside the table and then click the Table Design tab, you can check the Total Row box. There are other checkboxes here. I would recommend always having the Header Row checked. Also you probably always want the Filter Button to be checked.

Your table will look something like the one in the screenshot below after you add more aggregations. Notice that Excel uses the SUBTOTAL function.

Using Structured References with Excel Tables

When you create an Excel table, Excel assigns a name to the table, and to each column header in the table. That combination of table and column names is called a structured reference. To sum all of the salaries in the Salaries column in a table called tblEmployees you could write the formula =SUM(tblEmployees[Salaries]).