Excel > Excel 2003 Foundation > Formulas

Sum Function

The most commonly used Excel function is Sum. The purpose of the Sum function is to add up the numbers in a range.

Online Excel School

To use Sum:

  1. Select the cell where you wish the total to appear.
  2. Click the Sum button
  3. Sum button

  4. The Sum function appears in the cells and a dotted line appears around the cells Excel thinks you want to sum. If the range is not correct, select a different range
  5. Entering the Sum function

  6. Press Enter

The total appears in the cell. If a value in the summed range changes at a later date, the total will automatically update itself.

Sum can add more than one range if needed. To select a second range, enter a comma and select another range.

Follow us on

Facebook  Twitter  You Tube