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], …)
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
The SUM formula returns the mathematical sum of all of the numbers, cells, and/or ranges in the form of a single number.
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.