# 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(x_{1},x_{2},x_{3},...,x_{n}) = x_{1}^{2} + x_{2}^{2} + x_{3}^{2} + .... + x_{n}^{2}

## Examples:

Formula | Description | Returns |
---|---|---|

=SUMSQ(2;3;4) | sum of squares of 2,3,4 = 2^{2} + 3^{2} + 4^{2} |
29 |

## Related LibreOffice functions:

## ODF standard:

## Equivalent Excel functions:

SUMSQ