SUM (First, Other...) SUM (First; Other...)
First
The first number or array of numbers.
Other
Additional numbers or arrays of numbers.
Returns
Number Number
The sum of the given numbers.
Returns the sum of the provided values (added together). SUM (2, 3, 4) SUM (2; 3; 4) returns 9 and is equivalent to 2 + 3 + 42 + 3 + 4.
SUM also accepts arrays, meaning that these formulas are also valid:
SUM ({ 2, 3, 4 })
SUM ({ 2; 3; 4 })
SUM (2, { 3, 4 })
SUM (2; { 3; 4 })
Use SUMIF or SUMIFS to only consider values satisfying one or several conditions.