Returns the sum of the squares of a series of numbers and/or cells.

Sample Usage:





SUMSQ(value1, [value2, ...])

value1 - The first number or range whose squares to add together.

value2, ... - [ OPTIONAL ] - Additional numbers or ranges whose squares to add to the square(s) of value1.


If only a single number for value1 is supplied,SUMSQ returns value1 squared.

Although SUMSQ is specified as taking a maximum of 30 arguments, Google Sheets supports an arbitrary number of arguments for this function.

To use the SUMSQ Formula, simply begin with your edited Excellentable:

Then begin typing the SUMSQ formula in the area you would like to display the outcome: 

By adding the values you would like to calculate, Excellentable generates the outcome:



User does not have sufficient privileges to access this Content
Learn More