SUMSQ:
Returns the sum of the squares of the arguments
The SUMSQ function returns the sum of the squares of the arguments.
SUMSQ takes
1 required argument and
254 optional arguments:
Syntax: SUMSQ(number1,
[number2], ...
)
Using the SUMSQ function:
The arguments for the SUMSQ function are:
Argument

Required?

Description

number1, number2, ... 
Required 
number1 is required, subsequent numbers are optional. 1 to 255 arguments for which you want the sum of the squares. You can also use a single array or a reference to an array instead of arguments separated by commas. 
• The arguments should be either numbers or names, arrays, or references that contain numbers. 
• Numbers, logical values, and text representations of numbers that you type directly into the list of arguments are counted. 
• If an argument is an array or reference, only numbers in that array or reference are counted. Empty cells, logical
values, text, or error values in the array or reference are ignored. 
• Arguments that are error values or text that cannot be translated into numbers cause errors. 
The SUMSQ function returns the sum of the squares of the arguments.