Click anywhere in the table. The Table Design tab appears in the Ribbon. Click on Table Design. Then check Total Row. A new row is added at the end of the table with the total amount of sales revenue. You could also insert the total row with a keyboard shortcut: CTRL + SHIFT + T.
You can quickly total data in an Excel table by enabling the Toggle Total Row option. Click anywhere inside the table. Click the Table Design tab > Style Options > Total Row. The Total row is inserted at the bottom of your table.
Try out 5 different ways to total columns: find the sum of the selected cells on the Status bar, use AutoSum in Excel to sum all or only filtered cells, employ the SUM function or convert your range to Table for easy calculations. If you store such data as price lists or expense sheets in Excel, you may need a quick way to sum up prices or amounts.