Excel Tables have a **Total Row** that can be toggled on and off from the Ribbon. Several functions are available when the Total Row is turned on.

In Excel 2010 and 2007 (Windows) select a cell inside the Table, then choose **Table Tools** and click the check box for **Total Row**. In Excel 2011 (Mac) select a cell in the Table and choose **Tables**, then select the check box for **Total Row**.

A Total row appears below the data where each column has access to several automatic formulas. The default selection … Read the rest