How to Use SUMSQ Function

The SUMSQ function adds all the numbers' squares.


=SUMSQ(number1, [number2], …)


– Number1 is required, the first number to square then add.

– Number2… is optional, the second number to square then add.


– 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?


The result returns to 62 (=1^2+6^2+5^2)

Download: SUMSQ Function

Leave a Reply