SUMPRODUCT

The SUMPRODUCT function calculates the sum of the products of corresponding entries in 2 equally sized arrays or ranges.

Sample Usage

SUMPRODUCT(A2:C5,D2:F5)

SUMPRODUCT({1,2,3,4},{5,6,7,8})

Syntax

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

  • array1 - The first array or range whose entries will be multiplied with corresponding entries in the second such array or range.

  • array2, ... - [ OPTIONAL - {1,1,1,...} with same length as array1 by default ] - The second array or range whose entries will be multiplied with corresponding entries in the first such array or range.

Notes

  • Matrix multiplication, MMULT, can also be accomplished using a combination of TRANSPOSE and SUMPRODUCT functions.

See Also

TRANSPOSE: Transposes the rows and columns of an array or range of cells.

MMULT: Calculates the matrix product of two matrices specified as arrays or ranges.

Examples

Was this helpful?
How can we improve it?
true
Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Search
Clear search
Close search
Google apps
Main menu
Search Help Center
false
false
true
true
35
false
false