Excel - Microsoft Excel Sumsq Function

Description

The Excel Sumsq function returns the sum of squares of a supplied set of values. 

The format of the function is: 

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

where the number arguments are numeric values or arrays of values. These can be supplied to the function either directly, as values returned from other formulas, or as references to cells containing numeric values. 

If the values supplied to the function are text values, or logical values, these will be handled as follows: 

In Excel 2007 and Excel 2010, you can provide up to 255 number arguments to the function, but 

In Excel 2003, you can only provide up to 30 number arguments. 

Sumsq Function Examples

The spreadsheet below shows examples of the Sumsq function. 

The formulas are shown in the spreadsheet on the left and the results are shown in the spreadsheet on the right. 

The above examples show how the arguments to the function can be input as an array, or as multiple values, and how the arguments can be input both directly and as references to cells containing values. 

Sumsq Function Error

Although the Sumsq function is able to interpret logical values and text representations of numbers that are supplied directly to the function, as numbers, and will ignore text or logical values that are supplied via a cell reference, you may occasionally get the #VALUE! error returned from the function: 

Common Error