Skip to main content
Windward

SUMPRODUCT Function

Overviewautotag-wiki-logo.png

The SUMPRODUCT function

Multiplies corresponding components in the given ranges, and returns the sum of those products.

For example

=SumProduct(Range(1,2,3),Range(4,5,6)) returns 32

Syntax

SUMPRODUCT(range1,range2,...)
  • ​range - At least one range Required. The range  is an array of numbers.
  • Was this article helpful?