## What is SUMSQ Function in Excel?

The **SUMSQ **function is one of the math functions of Excel.

It Returns the **sum of the squares of the arguments**.

The arguments can be **numbers**, **arrays**, **names**, or **references **to cells that contain numbers.

We can find this function in **Math & trig** category of insert function Tab.

## How to use SUMSQ function in excel

- Click on
**an empty cell**(like F5 )

2. Click on **fx icon** (or press** shift+F3**)

3. In the **insert function tab** you will see all functions

4. Select **math and trig** category

5. Select **SUMSQ **function

6. Then select **ok**

7. In the function **arguments Tab** you will see ** SUMSQ **function

8. **Number1**,**number2**,… are **1 to 255 numbers**, arrays, names, or references to arrays for which you want the **sum of the squares**.

This function **first **obtains the square of each of the input values and then adds them together.

9. You will see **results **in the formula result section

## Examples of **SUMSQ **function in Excel

**Example 1:**

**How to use SUMSQ function in excel**

You can see examples of SUMSQ function below:

**sumsq**(A2,B2) ----->>>>answer is 5
**sumsq**(A3,B3) ----->>>>answer is 13
**sumsq**(A4,B4) ----->>>>answer is 25
**sumsq**(A5,B5) ----->>>>answer is 41
**sumsq**(A6,B6) ----->>>>answer is 61

## What is the purpose of **SUMSQ** function?

**SUMSQ**

It Returns the **sum of the squares of the arguments**.

## What is the Return value of **SUMSQ** function?

**SUMSQ**

It returns a number.

## How many arguments does **SUMSQ** function have?

**SUMSQ**

This function has just **1** Argument.

The **argument **of SUMSQ function is **number**.

**Number1**,**number2**,… are **1 to 255 numbers**, arrays, names, or references to arrays for which you want the **sum of the squares**.

This function **first **obtains the square of each of the input values and then adds them together.

The argument of SUMSQ function is **required **and not optional.

```
SUMSQ(number) = number
```

## Which version of excel supports **SUMSQ** function?

**SUMSQ**

This function is available for all excel **versions **(2003-2019)

## Errors in **SUMSQ** function

**SUMSQ**