To sum a Column in a Microsoft Excel spreadsheet, you can use the AutoSum, the Status Bar, and even the Sum function to calculate values in one or more columns ...

Enter a formula or use the AutoSum feature to total all values in a row in Excel. The AutoSum feature enables you to obtain a total for all values in a row or column at the click of a button.

In Excel 2007 the icon reads ”− AutoSum”. The total of the column will appear in the extra cell. Type ”Total” in the same row but in Column A.

When you click Excel's AutoSum button (the one in the toolbar that looks like Σ) from a cell next to a row or column of numbers, Excel automatically sums those numbers.