Apple Numbers '08 - Manual (Page 278)

278 Chapter 12 Dictionary of Functions
SUMIF
The SUMIF function calculates the sum of a set of numbers, but includes only numbers
that satisfy a specified condition. The condition that determines whether each number
is included can be performed on the number itself or on a corresponding value in a
second range of values.
SUMIF(test-range, "condition", [sum-range])
 test-range: A reference to the range of cells containing values to test. Must be the
same dimensions as sum-range.
 "condition": Any comparison statement that results in a logical TRUE or FALSE value.
 sum-range: Optional; a reference to the range of cells containing the numbers to be
added. Must have the same dimensions as test-range. If omitted, test-range is used.
Notes
For more information on the comparison operators you can use in the conditional test,
see “Understanding the Comparison Operators” on page 96.
SUMPRODUCT
The SUMPRODUCT function calculates the sum of the products of corresponding
numbers in two or more ranges of numbers. The ranges must have the same
dimensions.
SUMPRODUCT(range, range, [range, . . .])
 range: A reference to a range of cells containing numbers or numeric expressions.
Examples
Given the following table:
SUMIF(A1:A8, "<5") returns 10.
SUMIF(A1:A8, "<5", B1:B8) returns 100.
SUMIF(D1:F3, "=c", D5:F7) returns 27.
SUMIF(B1:D1, 1) or SUMIF(B1:D1, SUM(1)) both total all the occurrences of 1 in the range.