Section 10 - Auto Sum

Use the AutoSum button to automatically create a formula that adds a range of cells.

In Excel XP and MAC Excel 2004, the AutoSum button is located on the Standard Toolbar. In Excel 2007, the Auto Sum button is located under the Home tab in the Editing group.

Excel 2007

There are 2 ways to use the AutoSum button:

Select the range you want to add, then click the AutoSum button. The sum is placed in the next available cell.

OR

Select an empty cell next to the range, then click the AutoSum button. The AutoSum button creates a scrolling marquee to appear around the cells selected for inclusion.

If the default cells selected are not the correct data range, drag the mouse to include the range of cells to sum.

Click the <enter> or <return> key to complete the function.