SUM function

SUM(First, Other...) SUM(First; Other...)

First

Number or { Number }

The first parameter.

Other

Number or { Number } (accepts many)

Additional parameters.

Returns

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 })
SUM({ Field1, Field2, Field3 })SUM({ Field1; Field2; Field3 })
SUM(Field1:Field3)SUM(Field1:Field3)
SUM({ Field1:Field3, Field5, Field6 })SUM({ Field1:Field3; Field5; Field6 })

The Field1:Field3Field1:Field3 range is a short-hand way of expressing an array containing Field1 and Field3, as well as any fields that appear between them, such as Field2. If only Field2 appears between the other two fields, Field1:Field3Field1:Field3 and { Field1, Field2, Field3 }{ Field1; Field2; Field3 } are equivalent.

Use SUMIF or SUMIFS to only consider values satisfying one or several conditions.

Examples

SUM(1, 2, 3, 4)SUM(1; 2; 3; 4)

Returns 10 (1 + 2 + 3 + 41 + 2 + 3 + 4).

SUM(1, { 2, 3 }, 4)SUM(1; { 2; 3 }; 4)

Returns 10 (1 + 2 + 3 + 41 + 2 + 3 + 4).

SUM({ 1, 2, 3, 4 })SUM({ 1; 2; 3; 4 })

Returns 10 (1 + 2 + 3 + 41 + 2 + 3 + 4).

SUM(Field1:Field10)SUM(Field1:Field10)

Returns the sum of the field values belonging to the Field1:Field10Field1:Field10 range.