Syntax: = SUM( number1, [number2], [number3], â€¦)

The SUM formula adds together all of the numbers specified in the arguments. The arguments in the formula that are in brackets (i.e., [number2], [number3], etc., are optional.

The inputs can be numbers, formulas, a cell reference, or a range. If a range or cell reference is specified, only numbers, or text that Excel can convert into a number will be includedâ€”text, empty cells and logical values, such as the greater than or less than operators, will be ignored).

Note that if any of the arguments or cell values are errors (i.e., #N/A, #VALUE, etc.) the SUM formula will result in an error.

SUM examples:

=SUM( 1 , 2, 3, 4, 5, -1) This formula will add together each number specified and in this case the result will be 14.

=SUM(A1, B3, 2) This formula will add A1 and B3 and then add 2.

=SUM(A1:A5) This formula will add together each of the cells in the range

The SUM formula can also be used to add numbers together across multiple worksheets or files.