How to use the Excel SUMSQ function

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:

Excel SUMSQ function 1 - How to use the Excel SUMSQ function

Syntax:  =SUMSQ(B2:B14)

Result:

SUMSQ function - How to use the Excel SUMSQ function

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.

Add a Comment

Your email address will not be published. Required fields are marked *