Formulas and Functions

Related Topics
For related functions and additional information, see:
“AVERAGEIF” on page 233
“AVERAGEIFS” on page 234
“COUNTIF” on page 247
“COUNTIFS” on page 248
“SUMIF” on page 197
“Specifying Conditions and Using Wildcards” on page 360
“Listing of Numeric Functions” on page 167
“Value Types” on page 36
“The Elements of Formulas” on page 15
“Using the Keyboard and Mouse to Create and Edit Formulas” on page 26
“Pasting from Examples in Help” on page 41
SUMPRODUCT
The SUMPRODUCT function returns the sum of the products of corresponding
numbers in one or more ranges.
SUMPRODUCT(range, range…)
 range: A range of cells. range is a reference to a single range of cells containing
values of any type. If string or Boolean values are included in range, they are ignored.
 range…:Optionally include one or more additional ranges of cells. The ranges must
all have the same dimensions.
Usage Notes
The SUMPRODUCT function multiplies the corresponding numbers in each range Â
and then sums each of the products. If only one range is specied, SUMPRODUCT
returns the sum of the range.
Examples
=SUMPRODUCT(3, 4) returns 12.
=SUMPRODUCT({1, 2}, {3, 4}) = 3 + 8 = 11.
200 Chapter 8 Numeric Functions