Total the data in an Excel table - Microsoft Support
https://support.microsoft.com/en-us/office/total-the-data-in-an-excel-table-6944378f-a222-4449-93d8-474386b11f20
WEBSelect the column you want to total, then select an option from the drop-down list. In this case, we applied the SUM function to each column: You'll see that Excel created the following formula: =SUBTOTAL(109,[Midwest]). This is a SUBTOTAL function for SUM, and it is also a Structured Reference formula, which is exclusive to Excel tables.
DA: 22 PA: 50 MOZ Rank: 69