SUMSQ(num-value, num-value…)
num-value: A number value or collection containing number values.
num-value…: Optionally include one or more additional numbers or collections of numbers.
Examples
=SUMSQ(3, 4) returns 25.
=SUMSQ(A1:A4) adds the squares of the numbers in cells A1, A2, A3 and A4.
=SUMSQ(A1:D4) adds the squares of the 16 numbers in a square collection of cells A1:D4.
=SUMSQ(A1:A4, 100) adds the squares of the numbers in cells A1, A2, A3 and A4, and the number 100.
=SQRT(SUMSQ(3, 4)) returns 5, using the Pythagorean theorem to find the length of the hypotenuse of a triangle with sides 3 and 4.