Creating Calculations in a Table
You can quickly total data in a table using the Total Row option. When you display a total row at the end of the table, a drop-down list appears for each total cell along with the word Total in the leftmost cell. The drop-down list allows you to select a function to perform a calculation. If the function you want is not available in the drop-down list, you can enter any formula you want in a total row cell. If you’re not using a total function, you can delete the word Total.
Total the Data in a Table
Click a cell in a table.
Click the Design tab under Table Tools.
Select the Total Row check box.
The total row ...
Get Excel® 2013 On Demand now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
