Returns the sum of the squares of the arguments.
Syntax
SUMSQ(number1, [number2], ...)Argumente
number1erforderlich
The first number, cell reference, or range for which you want the sum of squares.
number2optional
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.