Navigation:  Formula Reference > Spreadsheet Formula Functions >

SUMSQ

Previous pageReturn to chapter overviewNext page

 

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

 

See Also

SUM

SUMPRODUCT