How to calculate the sum of the squares in Excel

Finding the sum of squares in Microsoft Excel can be a repetitive task. The most obvious formula requires a lot of data entry, although there is a lesser-known option that will take you to the same place.

Find the sum of squares for multiple cells

Start a new column anywhere in a Excel Spreadsheet and label it. Here we output the solution to our squares. The squares don’t have to be next to each other, and neither does the output section; it can be anywhere on the page.

Enter the following formula in the first cell of the new column:


Molecular formula Excel

From here you can manually add the letter and number combination to the column and row or simply click on it with the mouse. We’ll use the mouse, which will automatically fill this section of the formula with cell A2.

Add cell A2

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

Add cell b2

Close the clamp and press “Enter”On the keyboard to show the sum of the two squares. Alternatively, if you can continue from here, you can add additional cells by separating them with a comma within the formula.

close    Bracket

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

Find box

Click and drag the square down into the last row of pairs of numbers to automatically add the sum of the remaining squares.

pull down

Find the sum of the squares for just a few cells

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


simple formula for sums of squares

Alternatively, we can just add the numbers instead of the cells to the formula, as both paths bring us to the same place. This formula looks like this:

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

simple formula for sums of squares

You can modify these formulas as needed, change the cells, add additional numbers, or find the sum of the squares that aren’t even in your workbook, such as: example. And while it’s easier to follow the tutorial above by using the SUMSQ formula to find the solution to multiple squares, it’s often easier to just type in a quick formula like this when it’s not something you do will be repeated throughout the workbook.

Related Posts