Documentation/Calc Functions/SUMSQ

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

• Wiki Home
• Development
• Design
• QA
• Events
• Documentation
• Website
• Localization
• Accessibility
• Marketing
• Diversity
• Wiki Help

• Documentation Home
• Official Publications
• Other Resources
• FAQ
• HowTo
• Macros
• Docs Development

Calc Functions Home | List of functions | Abbreviations

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₁, N₂, …, N_k represent a set of 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 View ▸ Value Highlighting feature.

Examples:

Formula	Description	Returns
=SUMSQ(2; 3; 4)	Here the function calculates 22+32+42 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.22+32+(-5)2+1.32+(-7)2.	89.53
=SUMSQ({2; 4; 6; 8})	Here the function calculates 22+42+62+82 and returns the result.	120

Related LibreOffice functions:

POWER

SUM

ODF standard:

Section 6.16.65, part 2

Related (or similar) Excel functions:

SUMSQ