SUM

Calculates the arithmetic sum (total) of all specified numbers.

Syntax

=SUM(number1, number2, ..., numberN)

=SUM(numberArray)

Arguments

Argument	Type	Description
number	Number or Array	A number or array of numbers to sum

📘

If an array of values is supplied, the array will be flattened when summing. For example, =SUM(ARRAY(1,ARRAY(2,3)),ARRAY(4,5),6) returns 21 (1 + 2 + 3 + 4 + 5 + 6).

Examples

=SUM(1,2,3) → 6
Calculates the sum of 1, 2, and 3.

=SUM(ARRAY(4,5),6) → 15
Calculates the sum of an array containing 4, 5 and the number 6.

=SUM(children."Property 1") → 28
Calculates the sum of all children's data property values for "Property 1" (1, 4, 2, 6, 7, 8).