The SUMIFS function adds the cells in a range that meet multiple criteria.

SUMIFS takes 3 required arguments and 126 optional arguments:

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

Using the SUMIFS function:
The arguments for the SUMIFS function are:
Argument Required? Description
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, criteria_range2, ... Required The range in which to evaluate the associated criteria. Criteria_range1 is required. Subsequent criteria_ranges are optional. Up to 126 additional criteria ranges.
criteria1, criteria2, ... Required The criteria in the form of a number, expression, cell reference, or text that define which cells in the Criteria_range argument will be added. For example, criteria can be expressed as 32, ">32", B4, "apples", or "32." Criteria1 is required. Subsequent criterias are optional. Up to 126 additional criterias.
A few more things:
Each cell in the sum_range argument is summed only if all of the corresponding criteria specified are true for that cell. For example, suppose that a formula contains two criteria_range arguments. If the first cell of criteria_range1 meets criteria1, and the first cell of criteria_range2 meets critera2, the first cell of sum_range is added to the sum, and so on, for the remaining cells in the specified ranges.
Cells in the sum_range argument that contain TRUE evaluate to 1; cells in sum_range that contain FALSE evaluate to 0 (zero).
Unlike the range and criteria arguments in the SUMIF function, in the SUMIFS function, each criteria_range argument must contain the same number of rows and columns as the sum_range argument.


The SUMIFS function adds the cells in a range that meet multiple criteria.
comments powered by Disqus