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