SUMSQ function

Description

Returns the sum of the squares of the arguments. 

Syntax

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

The SUMSQ function syntax uses the following arguments: 

• Number1, number2, ...    Number1 is required. Subsequent numbers are optional. There can be as many as 255 arguments for which you want the sum of the squares. 

• Instead of comma-separated arguments, you can use a single array or a reference to an array. 

Remarks

• Arguments can be 
  > numbers 
  > names, arrays, or references containing numbers.

• The count includes numbers, logical values, and text representations of numbers typed into the list. 

• If an argument is an array or reference, only numbers in that array or reference are counted.
  This function will ignore empty cells, logical values, text, or error values in the array or reference. 

• Errors will occur from
  > arguments that are error values
  > text that cannot be translated into numbers 

Example

Copy the following example content and paste it in cell A1 of a new Excel worksheet. The formula cell may automatically show the numeric result. Otherwise select it, press F2, and press Enter.