SUMIFS:
Adds the cells in a range that meet multiple criteria
The SUMIFS function adds the cells in a range that meet multiple criteria.
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. 
• 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.