Excel AVERAGEIF Function
The AVERAGEIF function is a premade function in Excel, which calculates the average of a range based on a true or false condition.
It is typed
=AVERAGEIF and has three parts:
The condition is referred to as
criteria, which can check things like:
- If a number is greater than another number
- If a number is smaller than another number
- If a number or text is equal to something
[average_range] is the range where the function calculates the average.
[average_range] is optional.
If not specified, the function calculates the average of the same range as condition.
Note: The different parts of the function are separated by a symbol, like comma
, or semicolon
The symbol depends on your Language Settings.
Example AVERAGEIF function
Find the average speed of Grass type Pokemon:
The condition is that the type is "Grass".
Example AVERAGEIF function, step by step:
- Select the cell
- Double click the AVERAGEIF command
- Specify the range for the condition
B2:B10(the Type 1 values)
- Specify the criteria (the cell
E3, which has the value "Grass")
- Specify the range for the average
C2:C10(the Speed values)
- Hit enter
The function now calculates the average speed value of the Grass type Pokemon: Bulbasaur, Ivysaur and Venusaur.
The function can be repeated for Fire and Water type Pokemon to compare them:
Now, we can see the average speed values of each type: