FUNCTION CATALOGUE / STATISTICAL
AVERAGEIF Excel function
Averages values that meet one condition.
Correct sentence to use
Average [average range] where [criteria range] equals [value].
Modify this query in PlainFormula →Example formula
=AVERAGEIF(B:B,"London",D:D)
Averages values meeting a criterion.
Syntax
AVERAGEIF(range, criteria, [average_range])
Argument signature: range, criteria, [average_range]
Availability note
Commonly available in current Excel; verify platform and locale-specific behaviour.