This function returns the sum of the squares of the arguments.

Syntax

SUMSQ(value1,value2,...)

SUMSQ(array)

SUMSQ(array1,array2,...)

Arguments

Each argument can be a double-precision floating-point value, an integer value, or an array (cell range) of these. Up to 255 arguments may be included. You can use a single array (cell range) instead of a list of values. You can use multiple arrays (cell ranges) as well.

Data Types

Accepts numeric data for all arguments. Returns numeric data.

Examples

SUMSQ(A1,B7,C11)

SUMSQ(A1:A9)

SUMSQ(R1C2,R3C5,R6C2,R1C7)

SUMSQ(95,89,73,87,85,76,100,96,96) gives the result 71277

Version Available

This function is available in product version 1.0 or later.

See Also

SUMPRODUCT | SUM | Math and Trigonometry Functions