# SUMPRODUCT

Returns the sum of products for a list of arguments

## Syntax

```
SUMPRODUCT(array1, [array_n])
```

## Arguments

| Argument  | Description                                                  | Required |
|-----------|-------------------------------------------------------------|----------|
| `array1` | The first array or range to perform multiplication, then add | Required |
| `array_n`| Additional array or range to multiply, then add           | Optional |

## Examples

### Sum products of two arrays

=SUMPRODUCT(A1:A3, B1:B3)

Result ⇒38

|     |     |     |
|-----|-----|-----|
|     |  A  |  B  |
|  1  |  3  |  4  |
|  2  |  4  |  5  |
|  3  |  2  |  3  |

### Calculate total sales

=SUMPRODUCT(A1:A3, B1:B3)

Result ⇒165.75

|     |     |     |
|-----|-----|-----|
|     |  A  |    B     |
|  1  | 10  |  5.50  |
|  2  | 15  |  3.25  |
|  3  |  8  |  7.75  |

### Weighted average calculation

=SUMPRODUCT(A1:A3, B1:B3) / SUM(B1:B3)

Result ⇒85.6667

|     |     |     |
|-----|-----|-----|
|     |  A  |  B  |
|  1  | 85  |  3  |
|  2  | 90  |  4  |
|  3  | 78  |  2  |

## Related Functions

Other Statistical functions:

- [AVEDEV](/content/docs/formulas/avedev.html) 
- [AVERAGE](/content/docs/formulas/average.html) 
- [CORREL](/content/docs/formulas/correl.html) 
- [COUNT](/content/docs/formulas/count.html) 
- [COUNTA](/content/docs/formulas/counta.html) 
- [COUNTIF](/content/docs/formulas/countif.html) 
- [COUNTIFS](/content/docs/formulas/countifs.html) 
- [FORECAST](/content/docs/formulas/forecast.html) 
- [LARGE](/content/docs/formulas/large.html) 
- [MAX](/content/docs/formulas/max.html) 
- [MEDIAN](/content/docs/formulas/median.html) 
- [MIN](/content/docs/formulas/min.html) 
- [MINIFS](/content/docs/formulas/minifs.html) 
- [MODE](/content/docs/formulas/mode.html) 
- [PERCENTILE](/content/docs/formulas/percentile.html) 
- [PERCENTRANK](/content/docs/formulas/percentrank.html) 
- [RANK](/content/docs/formulas/rank.html) 
- [SMALL](/content/docs/formulas/small.html) 
- [STDEV](/content/docs/formulas/stdev.html) 
- [STDEVP](/content/docs/formulas/stdevp.html) 
- [SUMIF](/content/docs/formulas/sumif.html) 
- [VAR](/content/docs/formulas/var.html) 
- [VARP](/content/docs/formulas/varp.html)