SUMIFS

Adds the cells in a range that meet multiple criteria.

Syntax

SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)

Arguments

• sum_range: The range of cells to sum.
• criteria_range1: The range of cells that is tested using criteria1.
• criteria1: The criteria that defines which cells in criteria_range1 will be added.
• [criteria_range2, criteria2], ...: (Optional) Additional ranges and their associated criteria. You can enter up to 127 range/criteria pairs.

Example

SUMIFS(C2:C9, A2:A9, ">=5", B2:B9, "<10") → Returns the sum of values in C2:C9 where the corresponding value in A2:A9 is greater than or equal to 5, and the corresponding value in B2:B9 is less than 10.
SUMIFS(D1:D10, A1:A10, "Apples", C1:C10, ">50") → Returns the sum of values in D1:D10 where the corresponding value in A1:A10 is "Apples" and the corresponding value in C1:C10 is greater than 50.