AVERAGEIFS
Returns the average of all cells that meet multiple criteria
Syntax
AVERAGEIFS(average_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)
Parameters
- average_range: Required. The range of cells to average
- criteria_range1: Required. The first range to evaluate
- criteria1: Required. The first criteria
- criteria_range2: Optional. Additional ranges
- criteria2: Optional. Additional criteria
Example
=AVERAGEIFS(B2:B5, C2:C5, "Yes", D2:D5, ">100")