Article updated on March 13, 2018

The SUMSQ function calculates the sum of the squares of the arguments.

Formula in cell D3:

=SUMSQ(B3:B5)

2^2 = 4, 3^2 = 9, 4^2=16.

4+9+16 = 29

Excel Function Syntax

SUMSQ(number1, [number2], ...)

Arguments

number1 Required. The argument for which you want the sum of the squares.
[number2] Optional. Up to 253 additional number arguments.