All functions / Statistics

AVERAGEIFS

Averages the cells that meet every one of several conditions.

Syntax

=AVERAGEIFS(average_range, criteria_range, criteria, [criteria_range1, [criteria_range2], …])

Arguments

• average_range: The cells to average.
• criteria_range: A range to test.
• criteria: The condition.
• criteria_range (optional): More range/condition pairs.