How to Sum a Column or Row of Excel Cells

With AutoSum, you can add a range of cells in a flash! Plus, best of all, Excel will recalculate the sum whenever the cells you selected change. These steps are intended for Microsoft's Excel 97.

Difficulty: Moderately Easy

Instructions

Things You'll Need:

• Excel Book
• Microsoft Excel

1. Start Microsoft Excel and open the file you want to change.

2. Drag over the two or more cells you want to add.

3. Select the AutoSum icon on the tool bar.

Tips & Warnings

• The AutoSum icon looks like an odd-shaped E (a formula symbol).
• When totaling a row, the sum will appear in the first empty cell to the right.
• When totaling a column, the sum will appear in the first empty cell at the bottom.
• Click on the cell that contains the total to view the formula you just created. The formula, or equation, is displayed in the Formula Bar.
• The Formula Bar is located between the tool bar and the column heads.