Excel SUM Function
1The Excel SUM function returns the sum of values supplied. These values can be numbers, cell references, ranges, arrays, and constants, in any combination. SUM can handle up to 255 individual arguments.
Purpose
Add numbers together
Return value
The sum of values supplied.
Syntax
=SUM (number1, [number2], [number3], ...)
Arguments
number1 - The first value to sum.
number2 - [optional] The second value to sum.
number3 - [optional] The third value to sum.
Notes
SUM automatically ignores empty cells and cells with text values.
If arguments contain errors, SUM will return an error.
The AGGREGATE function can sum while ignoring errors.
SUM can handle up to 255 total arguments.
Arguments can be supplied as constants, ranges, named ranges, or cell references.