SUMIFS
Adds the cells in a range that meet multiple criteria.
Syntax
 Copy Code
|
|---|
SUMIFS( ReferenceOrArray sum_range, ReferenceOrArray criteria_range1, Any criteria1,;ReferenceOrArray criteria_range2;,;Any criteria2;, ... ) → Number |
sum_range | Required. The range of cells to sum. |
criteria_range1 | Required. The first range to evaluate with the associated criteria. |
criteria1 | Required. The criteria to use on the first range. |
criteria_range2 | Optional. Additional ranges and their associated criteria. |
criteria2 | Optional. The criteria to use on the second range. |
Each criteria range must have the same number of rows and columns as the sum_range.