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