Microsoft® Office Excel® 2007 Inside Out

Adding Totals to a Table

To add a total row to your table, select any cell within the table, and then select the Total Row check box in the Table Style Options group on the Designer tab. You can toggle the row on or off by selecting or clearing this check box. Figure 21-3 shows an example of a total row.

Figure 21-3. The total row uses the SUBTOTAL function to perform summary calculations.

By default, the total row applies the SUBTOTAL function, with a Function_num argument of 109, to the rightmost column of the table. (Using 109 in the Function_num argument creates a sum that ignores all rows hidden by filters.) That generates a sum in the lower-right ...