SUM
Adds all the numbers in the specified arguments.
Syntax
SUM(number1,number2,...)
Number1, number2, ... are 1 to 30 arguments for which you want the total value or sum.
Remarks
- Numbers, logical values, and text representations of numbers that you type directly into the list of arguments are counted. See the first and second examples following.
- Arguments cause errors if they are error values or text that cannot be translated into numbers.
Example
| Col1 | Col2 | Col3 | Col4 | Col5 | Formula | Description (Result) |
|---|---|---|---|---|---|---|
| -5 | 15 | 30 | TRUE | =SUM(3, 2) | Adds 3 and 2 (5) | |
| -5 | 15 | 30 | TRUE | =SUM("5", 15, TRUE) | Adds 5, 15 and 1, because the text values are translated into numbers, and the logical value TRUE is translated into the number 1 (21) | |
| -5 | 15 | 30 | TRUE | =SUM(Col1], [Col2], [Col3]) | Adds the first three numbers in the columns (40) | |
| -5 | 15 | 30 | TRUE | =SUM(Col1], [Col2], [Col3], 15) | Adds the first three numbers in the columns, and 15 (55) | |
| -5 | 15 | 30 | TRUE | =SUM([Col4], [Col5], 2) | Adds the values in the last two columns and 2 (2) |