How to

How to Calculate the Sum of Squares in Excel

Finding the amount of squares in Microsoft Excel can be a recurring job. The most apparent formula needs a lot of information 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 need to be next to each other, nor does the output section; it can be anywhere on the page.

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

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

Add a comma and after that we’ll include the next number, from B2 this time. Just type in B2 to the formula, or click the proper cell to autofill it.

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

To apply the formula to extra cells, search for the little filled square in the cell that contains the service to our very first problem. In this example, it’s C2.

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

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:

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

You can modify these solutions as needed, altering the cells, including extra numbers, or finding the amount of squares that aren’t even in your workbook, for example. And while it’s much easier to follow together with the above tutorial, utilizing the SUMSQ formula, to discover the service for several squares, it’s typically much easier to simply type out a fast formula like this if it’s not something you’ll be duplicating throughout the workbook.

It’s here that we’ll output the service of our squares. Close the parenthesis and press “Enter” on the keyboard to show the sum of both squares. To use the formula to additional cells, look for the small filled square in the cell that contains the solution to our very first problem.

Leave a Reply

Need help with the Commons? Visit our
help page
Send us a message