SUMIFS
Adds the cells in a range that meet multiple criteria
Syntax
SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)
Parameters
- sum_range: Required. The range of cells to sum
- criteria_range1: Required. The range tested using criteria1
- criteria1: Required. The criteria that defines which cells in criteria_range1 will be added
- criteria_range2: Optional. Additional range
- criteria2: Optional. Additional criteria
Example
=SUMIFS(A1:A10, B1:B10, "Yes", C1:C10, ">5")