Apple numbers User Manual

    Dictionary of Functions 

 

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.
  

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.

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.