Returns the sum of the squares of the arguments.
Syntaxis
SUMSQ(number1, [number2], ...)Argumenten
number1vereist
The first number, cell reference, or range for which you want the sum of squares.
number2optioneel
Additional numbers, cell references, or ranges, up to a maximum of 255 arguments.
The SUMSQ function calculates the sum of the squares of the provided numbers, arrays, or cell references. It is commonly used in statistical calculations, such as determining variance or standard deviation.
=SUMSQ(3, 4)→25Calculates 3 squared (9) plus 4 squared (16), which equals 25.
Select the cell
Click on the cell where you want the result to appear.
Enter the formula
Type =SUMSQ( followed by your numbers or cell ranges, then close the parenthesis.
Yes, SUMSQ ignores text, logical values, or empty cells within a range.