Table of Contents

## Summary

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.

## Formula

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

## Example

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

=SUM(F6:F16)

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