Excel SUM function


The Excel SUM function adds numerical values from user input, cells, and/or ranges. The SUM function is one of the most popular Excel functions. The cells and ranges do not have to be contiguous.


=SUM(number1, [number2], …)

Arguments (inputs)

number1 = the first number to be summed, can be either a number, cell reference, or range reference

number2 = [optional] all additional numbers to be summed are optional

Return value

The SUM formula returns the mathematical sum of all of the numbers, cells, and/or ranges in the form of a single number.


Excel SUM formula example

In the example above the SUM formula sums the range of cells between F6:F16.


The resulting sum of the range is returned in cell F18, a total of $10,030.