SUMSQ function
From Apache OpenOffice Wiki
< Documentation | How Tos
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
Trigonometric
Hyperbolic
Rounding and remainders
Logarithm/Powers
Bessel functions
Miscellaneous
SUMSQ
Returns the sum of the squares of the arguments.
Syntax:
SUMSQ(number1; number2; .... number30)
- number1 to number30 are up to 30 numbers or ranges of numbers which are squared and then summed.
Example:
SUMSQ(2; 3; 4)
- returns 29, which is 2*2 + 3*3 + 4*4.
SUMSQ(A1:A2)
- where A1 contains 1 and A2 contains 2 returns 5, which is 1*1 + 2*2.
See Also
