Documentation/Calc Functions/SUMSQ

From The Document Foundation Wiki
Jump to: navigation, search

Other languages:

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 square 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 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:

SUM

POWER

ODF standard:

Section 6.16.65, Part 2

Equivalent Excel functions:

SUMSQ