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.

To use Sum:

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



3. 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



4. 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.

BODMAS Functions

Guides