Total the Data in a Table : Table Calculation « Table « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Table
  3. Table Calculation
Click a cell in a table. 
           Click the Design tab under Table Tools. 
           Select the Total Row check box. 
           The total row appears as the last row.
Click a cell in a table. Click the Design tab under Table Tools. Select the Total Row check box.
Click the cell in the column for which you want to calculate a total, 
           and then click the drop-down list arrow.
Click the cell in the column for which you want to calculate a total, and then click the drop-down list arrow.
From the drop-down list, select the function.
From the drop-down list, select the function.








4.6.Table Calculation
4.6.1.Total the Data in a TableTotal the Data in a Table
4.6.2.Subtotal Data in a ListSubtotal Data in a List