Documentation/Calc Functions/SUMSQ
Jump to navigation
Jump to search
TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate
Function name:
SUMSQ
Category:
Mathematical
Summary:
Calculates the sum of the squares of a set of numbers.
Syntax:
SUMSQ(Number 1 [; Number 2 [; … [; Number 255]]])
Returns:
Returns a non-negative real number which is the sum of the squares of input numbers.
Arguments:
Number 1, Number 2, … , Number 255 are real numbers, references to cells or to cell ranges of numbers whose sum of squares is to be calculated.
Additional details:
- Cells containing non-numeric values are ignored.
- The formula for the SUMSQ function is:
SUMSQ(x1,x2,x3,...,xn) = x12 + x22 + x32 + .... + xn2
Examples:
Formula | Description | Returns |
---|---|---|
=SUMSQ(2;3;4) | sum of squares of 2,3,4 = 22 + 32 + 42 | 29 |
Related LibreOffice functions:
ODF standard:
Equivalent Excel functions:
SUMSQ