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.