» Total the Table in Excel 2007

To total Table last column:

1. Select a cell in the Table range.
2. Select Design tab (in Table Tools Ribbon) -> Totals Rows (in Table Style Options Group).
3. Select a function from the dropdown list in the last cell of the table, the default function is SUM.

Note:
Before using this option move the column containing numbers to be the last column of the Table.




To total Table columns:

1. Select a blank cell under one of the columns in the Table.
2. Click Formulas -> AutoSum (in Function Library Group) -> Sum.
Or
Press Alt+=>
3. Select a function from dropdown list under each column.