AVERAGEIFSReturns the average of a range depending on multiple criteria.
Sample Usage
AVERAGEIFS(A1:A10, B1:B10, “>20”)
AVERAGEIFS(A1:A10, B1:B10, “>20”, C1:C10, “<30") AVERAGEIFS(C1:C100, E1:E100, "Yes") Syntax AVERAGEIFS(average_range, criteria_range1, criterion1, [criteria_range2, criterion2, ...]) average_range - The range to average. criteria_range1 - The range to check against criterion1. criterion1 - The pattern or test to apply to criteria_range1. criteria_range2, criterion2, ... - [ OPTIONAL ] - Additional ranges and criteria to check. See Also AVERAGE: The AVERAGE function returns the numerical average value in a dataset, ignoring text. AVERAGEA: Returns the numerical average value in a dataset. AVERAGEIF: Returns the average of a range depending on criteria. SUMIFS: Returns the sum of a range depending on multiple criteria. COUNTIFS: Returns the count of a range depending on multiple criteria. IF: Returns one value if a logical expression is `TRUE` and another if it is `FALSE`. MEDIAN: Returns the median value in a numeric dataset.