Excel AVERAGEIFS Function

Syntax

=AVERAGEIFS(average_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)

Description

Calculates the average of cells that meet multiple criteria.
Example Excel File
AVERAGEIFS.xlsx · 21.4 KB

Enter your email to receive the example Excel file (link valid 24h).

Become a supporter — download instantly, no email

Related Functions