Adding Functions to Formulas Using the AutoSum Button

To add a function to a formula using AutoSum:

1. Click the cell in which you want to enter the formula.
2. Click the AutoSum button arrow.
3. Select the AutoSum function you want to use.
4. Excel automatically calculates the function using all contiguous cells above or to the left of the cell you selected.

Use the AutoSum button to quickly apply a function. First click the cell where you want to enter the formula. Next, click the AutoSum button arrow and select a function. Excel performs the calculation based on the data in the rows above the cell. Press Enter to accept the formula.