How to Calculate the Sum of Squares in Excel

  • You Must read the Blackvol Rules before making your first post otherwise you may get Permanent warning points or a Permanent Ban.

    Our resources on Blackvol Forum are CLEAN and SAFE. So you can use them for development and testing purposes. If you are on Windows and have an antivirus that alerts you about a possible infection : Know it's a false positive because all scripts are double-checked by our experts. We advise you to add Blackvol to trusted sites/sources or disable your antivirus momentarily while downloading a resource.

    Download NOTE : To download directly, please register on the site. After registration, you can see the download link at the top right of the page.

    "Enjoy Your Presence on Blackvol"

Maya

Active member
Jul 8, 2020
258
75
28
A Microsoft Excel Logo on a gray background



Finding the sum of squares in Excel can be a repetitive task. The most obvious formula requires a lot of data entry, though there’s a lesser-known option that gets you to the same place.

Finding the Sum of Squares for Multiple Cells

Start a new column anywhere in an Excel spreadsheet and label it. It’s here that we’ll output the solution of our squares. The squares don’t have to be next to each other, nor does the output section; it can be anywhere on the page.


add a new column



Type the following formula into the first cell in the new column:

=SUMSQ(

sumsq formula excel



From here you can add the letter and number combination of the column and row manually, or just click it with the mouse. We’ll use the mouse, which autofills this section of the formula with cell A2.


add cell a2



Add a comma and then we’ll add the next number, from B2 this time. Just type in B2 to the formula, or click the appropriate cell to autofill it.


add cell b2



Close the parenthesis and press “Enter” on the keyboard to display the sum of both squares. Alternatively, if you can keep going here, adding additional cells by separating each with a comma within the formula.


close parenthesis



To apply the formula to additional cells, look for the small filled square in the cell that contains the solution to our first problem. In this example, it’s C2.


find box



Click the square and drag it down to the last row of number pairs to automatically add the sum of the rest of the squares.


drag to bottom


Finding the Sum of Squares for Just a Few Cells

In our “Sum of Squares” column we created in the previous example, C2 in this case, start typing the following formula:

=SUM((A2)^2,(A3)^2)

simple formula for sum of squares



Alternatively, we can just add the numbers instead of the cells to the formula, as either way gets us to the same place. That formula looks like this:

=SUM((9)^2, (29)^2)

simple formula for sum of squares



You can alter these formulas as needed, changing the cells, adding additional numbers, or finding the sum of squares that aren’t even in your workbook, for example. And while it’s easier to follow along with the above tutorial, using the SUMSQ formula, to find the solution for multiple squares, it’s often easier to just type out a quick formula like this if it’s not something you’ll be repeating throughout the workbook.


Related :
 

Members online

No members online now.