SUM function
First
The first parameter.
Other
Additional parameters.
Returns
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:
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
Returns the sum of the field values belonging to the Field1:Field10Field1:Field10 range.