The Excel Sumsq function returns the sum of squares of a supplied set of values.
Syntax: =SUMSQ( number1, [number2], … )
The SUMSQ function syntax has the following arguments:
- Number1, number2, … Number 1 is required, subsequent numbers are optional. 1 to 255 arguments for which you want the sum of the squares. You can also use a single array or a reference to an array instead of arguments separated by commas.
Example: Let’s look at some Excel SUMSQ function examples and explore how to use the SUMSQ function as a worksheet function in Microsoft Excel:
Based on the Excel spreadsheet above, the following SUMSQ examples would return:
– The argument can be a number, cell reference, formula, or function that results in a number.
– Only numbers are counted. Text, error values, empty cells, and logical values are ignored.
– If an argument does not lead to a number, or results in an error value, the function itself may fail.