SUMSQ function in Excel – Calculate Sum of Squares in Excel

SUMSQ Function in Excel calculates and returns the sum of squares of numbers that has been passed as input.

Syntax of SUMSQ function in Excel

Syntax of sum of square function in excel is

SUMSQ( number1, [number2], … )

where the number  are numeric values (or arrays of numeric values) that you want to find the sum of squares


Example of SUMSQ function in Excel

The spreadsheets below show two examples of the Sum of square function in Excel.

Formula:SUMSQ Function in Excel 1

The arguments to the SUMSQ function can be given as input directly or as references to cells containing values

So the result will be

SUMSQ Function in Excel 2

NOTE :  #VALUE! Error occurs if the input arrays have different dimension

previous SUMSQ function in Excel                                                                                                           next SUMSQ function in Excel

DataScience Made Simple