# 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

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.

## Data Types

Accepts numeric data for all arguments. Returns numeric data.

## 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