Teach MeShow MeLet Me TryPrint

Creating Formulas Using the Sum Function

The SUM mathematical function is used to add several cells together. Instead of writing a formula with several references separated by a plus sign, you can "sum" a range of cells. A SUM function looks like this:

=SUM(A3:A6)

To use the SUM Function:

  1. Select the cell in which you want to enter the function.
  2. Click the Insert Function button.
  3. Click SUM from the list of Most Recently Used or Math & Trig functions and click OK.
  4. Enter the range of cells that you want to add.
  5. Click OK.

To enter an argument by dragging:

  1. Select the argument box in which you want to add the values.
  2. Click and drag on the worksheet to select the cells you want to add to the formula.
You can also enter the SUM function by: