# SUMPRODUCT

## Content

This function returns the sum of products of cells. Multiplies corresponding components in the given arrays, and returns the sum of those products.

## Syntax

`SUMPRODUCT(array1, [array2], ...)`

## Arguments

<span data-teams="true">This function has these arguments:</span>

| <span data-teams="true">Argument</span> | <span data-teams="true">Description</span> |
| -------- | ----------- |
| <span data-teams="true"> </span>*<span data-teams="true">array1</span>* | <span data-teams="true">[</span>Required<span data-teams="true">] </span>The first array argument whose components you want to multiply and then add. |
| <span data-teams="true"> </span>*<span data-teams="true">array2, ...</span>* | <span data-teams="true">[Optional] </span>Array arguments 2 to 255 whose components you want to multiply and then add. |

There must be at least two arrays ( *array1* , *array2* ) and optionally up to 255 arrays ( *array3* , ...) as arguments. The arrays must have the same dimension.

## Examples

`SUMPRODUCT(A1:A17,B1:B17,C1:C17)`
`SUMPRODUCT({2,3,5,6,4,7},{5,6,4,4,7,2})` gives the result 114