Microsoft Excel provides us with the option to calculate the Sum of Squares very easily. We can also compute the Sum of Squares using mathematical formulas in excel. In this article, we will see how we can find Sum of Squares quickly in simple methods in Excel.
1. Calculating Sum of Squares for Multiple Cells in Excel
Here, we will calculate the sum of squares for multiple cells using the SUMSQ Function. The SUMSQ Function returns the sum of squares of a series of values.
To make the explanation easier to understand we will use a dataset of some random record of numbers. The dataset has 3 columns; these are Record 1, Record 2 & Sum of Squares.
STEPS:
- Select Cell D5 at first.
- Now type the formula:
- Next, press Enter to see the result in Cell D5.
- Now, use the Fill Handle tool to see the results in the next cells.
- Finally, we can see results in all cells.
Read More: All the Easy Ways to Add up (Sum) a column in Excel
2. Using the Basic SUM Function
In this method, we will find the Sum of Squares by using the SUM Function. The SUM Function adds the numerical values in a range of cells.
We will use the same dataset used in Method 1.
STEPS:
- Firstly, select Cell D5.
- Now type the formula:
- Then press Enter to see the result.
- Finally, use the Fill Handle at Cell D5 and drag it till Cell D12 to see all results.
Read More: How to Sum Range of Cells in Row Using Excel VBA (6 Easy Methods)
3. Finding the Sum of Squares with Cell Ranges in Excel
We can also compute the sum of squares in a range of cells in Excel. It is very helpful when you have a large dataset.
We will use a dataset of numbers in this method. The dataset has 2 columns; these are List 1 & List 2. We will see the sum of squares in the last row of the table.
STEPS:
- Select Cell B10 at first.
- Next type the formula:
It will calculate the sum of squares from Cell B5 to Cell B9.
- Now press Enter and you can see the result.
- Use the Fill Handle to see the results in the adjacent cell.
Read More: How to Add Numbers in Excel (2 Easy Ways)
Similar Readings
- How to Sum Selected Cells in Excel (4 Easy Methods)
- [Fixed!] Excel SUM Formula Is Not Working and Returns 0 (3 Solutions)
- How to Sum Only Visible Cells in Excel (4 Quick Ways)
- Shortcut for Sum in Excel (2 Quick Tricks)
- How to Sum Colored Cells in Excel (4 Ways)
4. Calculating the Sum of Squares after Inserting Math Formula in Excel
Excel also gives us the freedom to calculate the sum of squares after performing any mathematical operation.
In this method, we will use a dataset of 3 columns; these are Data 1, Data 2 & Sum of Squares.
STEPS:
- In the first place, select Cell D5.
- Now put the formula :
Note: It will first divide Cell B5 by Cell C5 and store the value in the first argument. Then it will multiply Cell B5 with Cell C5 and store the value in the second argument. The SUMSQ Function will find the square of the two arguments and add them.
- Then press Enter to see the result.
- Finally, use the Fill Handle to AutoFill the rest of the cells.
5. Using IF Function to Find the Sum of Squares in Excel
Sometimes we face certain criteria to calculate the sum of squares. In those cases, we can use the IF function inside the SUMSQ function to find the sum of squares.
Suppose, we will calculate the sum of squares if the value of the first argument of the SUMSQ function is greater than 10. We will use the previous dataset in this method.
STEPS:
- Select Cell D5 at first.
- Now type the formula:
Note: If the value of Cell B5 is greater than 10, it will take the input in the first argument. Otherwise, it will take 0 as input.
- Next, press Enter to see the result.
- Finally, use the Fill Handle tool to AutoFill the formula for the rest of the cells.
Read More: Excel Sum If a Cell Contains Criteria (5 Examples)
6. Computing Sum of Squares by Multiplication in Excel
We can also compute the sum of squares by multiplying the cell by itself in Excel. After multiplication, we just need to add the values by the SUM Function. It is another easy way to find the sum of squares which we will apply in the below article.
We will use the previous dataset here.
STEPS:
- Firstly, select Cell D5.
- Secondly, type the formula:
- Thirdly, press Enter to see the result.
- Lastly, use the Fill handle tool to AutoFill the remaining cells.
Download Practice Workbook
Conclusion
By using these methods, we can calculate the Sum of the Squares very quickly. We can also use these methods if we face certain conditions. A practice book is also added above for your use. Finally, if you have any queries or suggestions, please feel free to comment below.
Further Readings
- Sum If a Cell Contains Text in Excel (6 Suitable Formulas)
- How to Add Multiple Cells in Excel (6 Methods)
- Excel Sum Last 5 Values in Row (Formula + VBA Code)
- How to Sum Cells with Text and Numbers in Excel (2 Easy Ways)
- Sum Cells in Excel: Continuous, Random, With Criteria, etc.
- How to Sum Multiple Rows and Columns in Excel