You can quickly total data in an Excel table by enabling the Total Row option, and then use one of several functions that are provided in drop-down lists for each totals row. A Total row can automatically calculate totals, and it keeps track of values you enter as you enter them. It can also give you averages and counts, among other options.
Enter your data in the workbook, and click any single cell within the set.
Click Insert > Table. The Create Table dialog box opens.
Review the cells selected in the Create Table dialog box. If you have headers for each column of data, select the My table has headers checkbox.
Tip: You can also use your cursor to select what cells to include in your table. With the Create Table dialog box open, click the first cell in the first column that contains your data. Drag your cursor to select your cells.
Click OK to create your table.
Click anywhere inside the table.
Click Design, and select the check box for Total Row.
The Total row is inserted at the bottom of your table.
Note: If you want to copy a sum to an adjacent cell in the table, drag the cell using the fill handle across or down. This will update the column references accordingly and display the correct value. Do not copy and paste a sum in the table as this will not update the column references, and will result in inaccurate values.
You can also apply a different function to the total value. To do that, click the dropdown next to the total value and select a function.
For example, you can have the total display the average value in a table containing sales data.
Or lookup a value in a table.