SUMSQ Function in Excel calculates and returns the sum of squares of numbers that has been passed as input.
Syntax of SUMSQ function in Excel
Syntax of sum of square function in excel is
SUMSQ( number1, [number2], … )
where the number are numeric values (or arrays of numeric values) that you want to find the sum of squares
Example of SUMSQ function in Excel
The spreadsheets below show two examples of the Sum of square function in Excel.
Formula:
The arguments to the SUMSQ function can be given as input directly or as references to cells containing values
So the result will be
NOTE : #VALUE! Error occurs if the input arrays have different dimension