How to Use SUMSQ Function

The SUMSQ function adds all the numbers' squares.

Formula:

=SUMSQ(number1, [number2], …)

Explanations:

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

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

Cautions:

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

=SUMSQ(1,5,6)

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

Download: SUMSQ Function

Leave a Reply