SUMIFS
Category: Mathematical Function.
Description: Sums the cells in a range that meet multiple criteria.
Syntax: SUMIFS(sum_range, criteria_range1, criteria1, criteria_range2, criteria2, …)
Sum_range is the range of cells to sum.
Criteria_range specifies the range in which to evaluate the specified criteria.
The criteria is a number, expression, cell reference or text that defines which cells in the criteria_range argument will be added.
You can specify several criteria ranges with specific criteria for each.