The AVERAGEIF function is a premade function in Excel, which calculates the of a range based on a true or false condition.

It is typed =AVERAGEIF and has three parts:

=AVERAGEIF(range, criteria, [average_range])

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 =

The [average_range] is the range where the function calculates the average.

Note: The [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 .

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:

  1. Select the cell F3
  2. Type =AVERAGEIF
  3. Double click the AVERAGEIF command

  1. Specify the range for the condition B2:B10 (the Type 1 values)
  2. Type ,
  3. Specify the criteria (the cell E3, which has the value "Grass")
  4. Type ,
  5. Specify the range for the average C2:C10 (the Speed values)
  6. 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:

Note: You can use the for the other rows, but make sure to use for the ranges.

Now, we can see the average speed values of each type: