All functions / Statistics
AVERAGEIF
Averages the cells that meet a condition.
Syntax
=AVERAGEIF(range, criteria, [average_range])
Arguments
range: The cells to test.criteria: The condition.average_range(optional): The cells to average. Leave out to average the tested cells.
Example
=AVERAGEIF(A2:A9, "East", C2:C9) → Average East sale