Excel 2010: SUMSQ function

Excel SUMSQ is very useful function when you need to return the sum of squares of the specified values in spreadsheet, rather than going for manual evaluation. It would be more useful by providing it with location of cells as function arguments where the data is residing, but you can directly put in values as argument to get them evaluated.

Launch Excel 2010 spreadsheet on which you want to apply SUMSQ function. For instance, we have included a spreadsheet containing fields, S.No, Series 1, Series 2 and Sum of SQRT.

Now we will find out the square of both values in Series 1 and Series 2 field and show sum of the resultant values. For this we will be using SUMSQ function.

The syntax of SUMSQ function is;

=SUMSQ(number1, number2…)

We will be putting location of cells as arguments in the function and write this function in first row of SUM Of SQRT field as;


The function arguments B2 and C2 are the location of cells. It will yield SUM of values after taking square of both values, as shown in the screenshot below.

sumsq1 Excel 2010: SUMSQ function

Drag the plus sign at the end of the cell towards the end of column to apply it over the Sum Of SQRT field.

sum sq all

If you want, you can evaluate SUMSQ function exclusively by putting in values directly.

direct values

Now for using this function by giving direct value and location of cells simultaneously, you will need to write it as;

=SUMSQ(location_of_cell, number)


You can also check out previously reviewed Excel function; DOLLAR, SUMPRODUCT, SUMIF, COUNTIF, VLOOKUP, HLOOKUP ,PMT, and LEN.

قالب وردپرس

About Alyse Kalish

Alyse Kalish
As an Associate Editor for The SalesJobInfo, Alyse is proud to prove that yes, English majors can change the world. She calls many places home, including Illinois where she grew up and the small town of Hamilton where she attended Colgate University, but she was born to be a New Yorker. In addition to being an avid writer, Alyse loves to dance, both professionally and while waiting for the subway.

Leave a Reply

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