Related Function:

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

### Syntax

=SUMSQ(num_1,[num_2], … )

Note: Beginning with Excel 2007, you can enter up to 255 number arguments to the function. Excel 2003 would only accept up to 30 number arguments.

#### Arguments

Argument Description
num_1,
[num_2], …
num_1 is required, subsequent numbers are optional. 1 to 255 values for which you want the sum of the squares

 • Arguments can either be numbers or names, arrays, or references that contain numbers • Numbers, logical values, and text representations of numbers that you type directly into the list of arguments are counted • If an argument is an array or reference, only numbers in that array or reference are counted. Empty cells, logical values, text, or error values in the array or reference are ignored

#### Examples

A B C
1 Formula Result Notes
2 =SUMSQ(3,4) 25 Sum of the squares of 3 and 4, i.e. 9 + 16 = 25
3 =SUMSQ(5,2,3) 38 Sum of the squares of 5, 2, and 3, i.e. 25 + 4 + 9 = 38

#### Common Function Error(s)

Problem What went wrong
#VALUE! Occurs if a value supplied directly to the function, cannot be interpreted as a numeric value