The SUM function let’s you easily add two or more numbers. You can also use it to add all values in a given range of cells. It is extremely useful for finding the sum of all values in a column or row.

### Syntax

To use the SUM formula, use the following syntax:

…where both number1 and number2 are either numbers or references to cells containing numbers.

### How to use it

For example, you could add two numbers like this:

Adding more than two numbers is just as easy:

This can just as easily be done by using =1+2+3+4+5. But the SUM function really begins to shine when you make use of cell references. We can add the contents of two cells like this:

You can combine cell references and real numbers into one SUM:

We add an entire range of cells by placing a semicolon between the first and last cell references of the range.

The most common use for this is to add all values in a column:

The easiest way to sum a column of values is to select the column and then to click on AutoSum in the Editing group on the Home tab: