## What is SUMPRODUCT function in Excel?

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

It Returns the **sum of the products** of corresponding ranges or arrays.

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

## How to use SUMPRODUCT 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 **SUMPRODUCT** function

6. Then select **ok**

7. In function arguments Tab you will see **SUMPRODUCT **function

8. The **array1**,array2,… are **2 to 255 arrays **for which you want to multiply and then add components. All arrays must have **the same dimensions**.

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

## Examples of **SUMPRODUCT** function in Excel

**Example 1:**

**How to use SUMPRODUCT function in excel**

You can see examples of SUMPRODUCT function below:

**sumproduct**(A2,B2) ----->>>>answer is 2
**sumproduct**(A3,B3) ----->>>>answer is 6
**sumproduct**(A4,B4) ----->>>>answer is 12
**sumproduct**(A5,B5) ----->>>>answer is 20
**sumproduct**(A6,B6) ----->>>>answer is 30

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

**SUMPRODUCT**

It Returns the **sum of the products** of corresponding ranges or arrays.

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

**SUMPRODUCT**

It returns a number.

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

**SUMPRODUCT**

This function has just **1 **Argument.

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

The **array1**,array2,… are **2 to 255 arrays **for which you want to multiply and then add components. All arrays must have **the same dimensions**.

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

```
SUMPRODUCT(number) = number
```

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

**SUMPRODUCT**

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

## Errors in **SUMPRODUCT** function

**SUMPRODUCT**

## SUMPRODUCT** related functions :**

- SUM function
- SUMSQ function
- SUMIF function
- SUMIFS function
- COUNTIF function
- COUNTIFS function