The Excel Sumsq function returns the sum of squares of a supplied set of values.
The syntax of the function is:
where the number arguments are numeric values (or arrays of numeric values) that you want to find the summed squares of.
If the values supplied to the function are text values, or logical values, these will be handled as follows:
In current versions of Excel (Excel 2007 and later), you can provide up to 255 number arguments to the Sumsq function, but in Excel 2003, the function can only handle up to 30 number arguments.
The spreadsheets below show two examples of the Sumsq function.
The above examples show how:
Further details and examples of the Excel Sumsq function are provided on the Microsoft Office website.
If you get an error from the Sumsq function, this is likely to be the #VALUE! error:
|#VALUE!||-||Occurs if a value that is supplied directly to the function cannot be interpreted as a number.|