If you want to **find the sum of the squares of the values provided** in the Excel spreadsheet, you can use the SUMSQ function in the worksheet. To use this function, you need to follow the steps given below. We all know that Excel is a powerful tool that helps to perform various **mathematical and logical operations** quickly.

Today, we will help you to know how to **use the Excel SUMSQ function** in the worksheet. Get an official version of MS Excel from the following link:

https://www.microsoft.com/en-in/microsoft-365/excel

## Description of SUMSQ Function

- It is one of the built-in functions in Microsoft Excel.
- This function helps to find the
**sum of the squares of the values provided**in the Excel spreadsheet. - The input values can be supplied as constants, cell references, or ranges.

## Syntax

- Here, you will see the syntax of the SUMSQ function.
- To apply this function on your spreadsheet, you have to
**select a cell**and**enter the formula**in the following format. - Once you enter the formula, just
**click**on the**Enter**button to get the result.

**=SUMSQ(number1, [number2], …)**

**Syntax Explanation:**

**number 1**– The first argument containing numeric values.**number 2**– It is an optional one. The first argument contains numeric values.

**Note:**

1) The input arguments can be a mix of **constants**, **names**, **arrays**, or **references **that contain numbers.

2) **Empty cells**, **logical values**, and **text values are ignored **if we give them as input.

3) The logical values **TRUE **and **FALSE **are evaluated as **1 **and** 0** respectively, when we use them as arguments.

## Examples

Here we come up with some examples to know how to apply the Excel SUMSQ function in the worksheet.

- Initially, you have to
**open**your**Excel workbook**on your PC and launch a worksheet that has data. - For example, we have given the array of
**input values**in the range**B3:E7**, as shown below.

- Then, we have to
**apply the above-mentioned formula**to get the result, as shown in the following screenshot.

- Finally, we need to
**click**on the**Enter**button to get the result. Drag down the first cell to fill the remaining cells.

**Empty cells**,**logical values**, and**text values are ignored**if we give them as input.

## Conclusion

From this post, we have demonstrated how to find the sum of the squares of the values provided in the Excel spreadsheet using the **SUMSQ function**. We hope that the given examples let you understand the concept easily. To learn more about Excel functions, then visit our webpage Aawexcel.com.

## Video Tutorial

The following video will show you how to apply the Excel SUMSQ function in the spreadsheet.

**Read Also:**

- How to Use Excel FLOOR.MATH Function?
- How to Use Excel FLOOR Function?
- How to Use Excel CEILING.PRECISE Function?
- How to Use Excel CEILING Function?
- How to Use Excel GCD Function?

Hi there, I’m **Sridhar** – an Excel enthusiast with over **10 years** of experience working with software. I’m passionate about using Excel to solve complex problems and streamline business processes. Over the years, I have helped businesses of all sizes to improve their **operations and save time and money**.

Aside from working with Excel, I also enjoy writing and sharing my knowledge with others. You’ll often find me contributing to the AAW Excel blog, where I provide tips, tricks, and tutorials that are easy to understand for readers of all skill levels.