Excel® 2013 On Demand

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 ...