FUNCTION CATALOGUE / STATISTICAL
AVERAGEIFS Excel function
Averages values that meet multiple conditions.
Correct sentence to use
Average [average range] where [condition 1] and [condition 2].
Modify this query in PlainFormula →Example formula
=AVERAGEIFS(D:D,B:B,"London",C:C,">100")
Averages values meeting all criteria.
Syntax
AVERAGEIFS(average_range, criteria_range1, criteria1, …)
Argument signature: average_range, criteria_range1, criteria1, …
Availability note
Commonly available in current Excel; verify platform and locale-specific behaviour.