The SUMSQ function adds all the numbers' squares.
Formula:
=SUMSQ(number1, [number2], …)
Explanations:
– Number1 is required, the first number to square then add.
– Number2… is optional, the second number to square then add.
Cautions:
– The SUMSQ Function only counts the numbers, all text or logical values are ignored.
Example: What is the sum of the square of 1, 5, and 6?
=SUMSQ(1,5,6)
The result returns to 62 (=1^2+6^2+5^2)