Formulas and Functions
SUMSQ
The SUMSQ function returns the sum of the squares of a collection consisting of number values.
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. |