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.

**Table of Contents**hide

## 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:

**=SUMSQ(B5,C5)**

**Â**

** **

- 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:

**=SUM(B5^2,C5^2)**

**Â**

- 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:

**Â =SUMSQ(B5:B9)**

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 :

**=SUMSQ(B5/C5,B5*C5)**

**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:

**=SUMSQ(IF(B5>10,B5,0),C5)**

** **

**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:

**=SUM(B5*B5,C5*C5)**

- 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**