Related Tutorial: Excel 2007 2010 AutoSum
Excel 2003 AutoSUM
The AutoSUM button, located on the Standard Toolbar in Excel 2003, is a shortcut provided for using the SUM function. When you click on the AutoSUM button, the SUM function is entered into the active cell.
To use the AutoSUM button
- Click on the cell where you want the answer to appear.
- Click on the AutoSUM button.
- The function will auto select the closest range of data cells. The selected cells are surrounded by the marching ants.
- Check to make sure that the selected range for the function is correct.
- If it is correct, press Enter on the keyboard.
- If it is incorrect, drag select with the mouse the correct range and then press Enter on the keyboard.
AutoSUM's rules for selecting a range
The order that AutoSUM follows in suggesting a range of data for the function is:
- The uninterrupted group of cells containing data above the active cell.
- The uninterrupted group of cells containing data to the left of the active cell.
- If there is no data in the cells above or to the left, AutoSUM doesn't select a range, but waits for you to do so.
Note: Do not assume that the range that AutoSUM selects is always correct.
- Excel AutoSUM Function (video)