Adding Functions to Formulas Using the AutoSum Button

Functions are built-in calculations that are used in formulas. You can quickly add a function to a formula by using the AutoSum button. The AutoSum button will use the data from the rows above or the columns to the left of the cell to perform the calculation.

To add a function to a formula:

  1. Click the cell in which you want to enter the formula.
  2. Click the AutoSum button arrow.
  3. Click the function you want to use.


Click the Insert Function button next to the formula bar or click More Functions... on the menu to create more sophisticated functions.

The AutoSum button allows you to quickly add a Sum function, Average function, Count function, Minimum function, or Maximum function to your workbook.