Documentation/Calc Functions/SUMSQ

Function name:
SUMSQ

Category:
Mathematical

Summary:
Calculates the sum of the squares of a set of real numbers.

Syntax:
SUMSQ(Number 1 [; Number 2 [; … [; Number 255]]])

Returns:
Returns a non-negative real number that is the sum of the squares of the specified numbers.

Arguments:
Number 1, Number 2, …, Number 255 give the set of real numbers for which the sum of the squares is to be calculated. Each argument may take one of the following forms:
 * A real number, or an expression that evaluates to a real number.
 * A reference to a single cell containing a real number.
 * A simple reference to a cell range containing real numbers (for example, A1:B9).
 * The name of a named range, comprising cells containing real numbers.
 * The name of a database range, comprising cells containing real numbers.
 * An inline array of real numbers (for example, {1.1, 2.2, 3.3, 4.4}).

Note that although SUMSQ can accept up to 255 arguments, each argument could specify a range of cells. This means that the number of real numbers processed could be many more than 255.

The following conditions (including errors) may be encountered:
 * If any argument is a string in quotation marks, then SUMSQ reports a #VALUE! error.
 * Text in cells and empty cells are ignored.
 * If there are no supplied numbers, then SUMSQ returns the value 0.
 * If only one value is supplied, then SUMSQ returns that value squared.

Additional details:

 * If N1, N2, …, Nk represent a set of k real numbers passed to the function, the formula for SUMSQ is:

$$\text{ SUMSQ }(N_{1}; N_{2}; ...; N_{k})=N_{1}^2+N_{2}^2+...+N_{k}^2$$


 * SUMSQ ignores any text in cells or empty cells. If you suspect wrong results, look for text within the supplied data range(s). To highlight text content within a data range, use Calc's feature.

Related LibreOffice functions:
POWER

SUM

ODF standard:
Section 6.16.65, part 2

Equivalent Excel functions:
SUMSQ