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])
- range: The range of cells evaluated against the criteria.
- criteria: The condition that determines which cells are averaged.
- average_range (optional): The actual cells to average. If omitted, Excel averages the 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(B3:B7, \"Monday\", D3:D7) in Excel.
=AVERAGEIF(G3:I3, \">6\") in Excel.