OpenOffice3.org Calc 3. Mathematical Functions

SUM(number 1; number2; ...) Function

Returns the sum of the all numbers given as arguments. The function accepts minimum 1 and maximum 30 arguments. Each argument may be a number or reference to a range of cells that contain numbers used for the calculation. For example:

=SUM(2;4;6;3) Returns 15. Corresponds to the sum of the 4 arguments.
=SUM(D3:E5) returns the sum of the numbers in the range D3:E5.

 

Back to the list of mathematical functions