OpenOffice3.org Calc 3. Mathematical Functions

SUMSQ(number 1; number2 ; …) Function

Returns the sum of the squares of the numerical values given as arguments. This function returns a numeric value. Admits minimum 1 and maximum 30 arguments. Each argument can contain a numeric value or a reference to a range of cells containing the numbers used to calculate the result. For Example:

=SUMSQ( 4;2) Returns 20, because 4*4 + 2*2 = 20.
=SUMSQ(5) Returns 25. When there is only one number as argument, calculates the square of that number.

 

Back to the list of mathematical functions