SUMIFS function

Category: Mathematical functions

What does this function do?

Add the cells specified by a given set of conditions or criterias.

Syntax:

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

• sum_range (required): One or more cells to sum, including numbers or names, ranges, or cell references that contain numbers. Blank and text values are ignored.

• criteria_range1 (required): The first range in which to evaluate the associated criteria.

• criteria1 (required): The criteria in the form of a number, expression, cell reference, or text that define which cells in the criteria_range1 argument will be added. For example, criteria can be expressed as 32, ">32", B4, "apples", or "32."

• criteria_range2, criteria2, …(optional): Additional ranges and their associated criteria. Up to 127 range/criteria pairs are allowed.

Examples:

Imagine we have the following range A1: C3

2	5	10
3	3	25
4	2	36

=SUMIFS(A1:A3,B1:B3, ">2") = Sum the values in A1: A3 values provided in B1: B3 that are higher than 2 = 5

=SUMIFS (A1: A3, B1: B3, ">2", C1: C3,25) = Sum the values in A1: A3 values provided in B1: B3 that are higher than the values 2 and C1: C3 that are equal to 25 = 3