Sum

Calculates the numerical sum of the values in a list of values, ranges and/or lists.

Syntax

Sum(param1, param2, ...)
Somme(param1, param2, ...)
param1 = first parameter to add (value, range, or list)
param2 = second parameter to add (value, range, or list)
... = nth parameter to add (value, range, or list)

Remarks

This function accepts an unlimited number of parameters.

Starting with version 6.8, sums are calculated using Kahan's method, with increased precision.

Examples

Sum(1, 2) = 3
Sum(A1:B3) = the sum of all of the numerical values in the A1:B3 range

Classification

Maths Ranges Statistics