beautypg.com

Sumproduct, 200 sumproduct – Apple iWork '09 User Manual

Page 200

background image

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 specified, 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