September 23, 2023

# 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: 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.

READ:  How to use DAYS360 Function in Excel #### Excel

View all posts by Excel →