AVERAGEIF Function in Excel

What is the AVERAGEIF Function?

The AVERAGEIF() function is used to calculate the average of values that meet specific criteria. This function is especially useful for conditional data analysis.

Syntax

=AVERAGEIF(range, criteria, [average_range])

Examples

Calculate the average of values in cells G3:I3 greater than 6:

=AVERAGEIF(G3:I3, ">6") → 7.5

Calculate the average in D3:D7 where B3:B7 equals "Monday":

=AVERAGEIF(B3:B7, "Monday", D3:D7) → 25000
AVERAGEIF Function Example in Excel
Example of =AVERAGEIF(B3:B7, \"Monday\", D3:D7) in Excel.
AVERAGEIF Result in Excel
Result of =AVERAGEIF(G3:I3, \">6\") in Excel.