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:
Syntax: =SUMSQ(B2:B14)
Result:
Based on the Excel spreadsheet above, the following SUMSQ examples would return:
Syntax: =SUMSQ(C2:C14)
Result: 394
Syntax: =SUMSQ(B13/B2,B2+B3)
Result: 34
Syntax: =SUMSQ(B2:B4,2,3)
Result: 75
Syntax: =SUMSQ(B2:B4,C2:C4)
Result: 112
Syntax: =SUMSQ(B2:B4,C2:C3)
Result: 103
Syntax: =SUMSQ(B2:B4,5)
Result: 87
Syntax: =SUMSQ(B2:B4,C2:C4,3)
Result: 121
Syntax: =SUMSQ(B2:B4,C2:C4,3,2)
Result: 125
Note:
– 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.