# Documentation/Calc Functions/SUMSQ

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 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
*N*,_{1}*N*, …,_{2}*N*represent a set of_{k}*k*real numbers passed to the function, the formula for SUMSQ is:

[math]\displaystyle{ \text{SUMSQ}(N_{1}; N_{2}; ...; N_{k})=N_{1}^2+N_{2}^2+...+N_{k}^2 }[/math]

- 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.

## Examples:

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

=SUMSQ(2; 3; 4) | Here the function calculates 2^{2}+3^{2}+4^{2} and returns the result. |
29 |

=SUMSQ(A1:A3; B1:B2) where cells A1, A2, A3, B1, and B2 contain the numbers 2.2, 3, -5, 1.3, and -7 respectively. | Here the function calculates 2.2^{2}+3^{2}+(-5)^{2}+1.3^{2}+(-7)^{2}. |
89.53 |

=SUMSQ({2; 4; 6; 8}) | Here the function calculates 2^{2}+4^{2}+6^{2}+8^{2} and returns the result. |
120 |

## Related LibreOffice functions:

## ODF standard:

## Equivalent Excel functions:

SUMSQ