SUMSQ
Name
Sum of the squares
Description
Returns the sum of the squares of the arguments.
Syntax
SUMSQ(value1, value2, . . . )
Remarks
Accepts up to 30 arguments. Each argument can be a cell, a cell range, a float value, or an integer value.
See also SUM.
Data Type
Accepts numeric data for all arguments. Returns numeric data. For more information, see Data Type for Each Cell Type.
Example
SUMSQ(R1C2,R3C5,R6C2,R1C7)
SUMSQ(A1,B7,C11)
SUMSQ(A1:A9)
SUMSQ(95,89,73,87,85,76,100,96,96)=71277