This function returns the sum of the squares of the arguments.
SUMSQ(value1,value2,...)
SUMSQ(array)
SUMSQ(array1,array2,...)
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.
Accepts numeric data for all arguments. Returns numeric data.
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