Login

AVERAGEIFS Function

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

It is typed =AVERAGEIFS:

=AVERAGEIFS(average_range, criteria_range1, criteria1, ...)

The conditions are referred to as critera1, criteria2, .. and so on, 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 criteria_range1, criteria_range2, and so on, are the ranges where the function check for the conditions.

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

Note: The different parts of the function are separated by a symbol, like comma , or semicolon ;

The symbol depends on your .

Example AVERAGEIFS function

Find the average defense of Grass type 1st Generation Pokemon:

The conditions are that the type is "Grass" and Generation is 1.

Example AVERAGEIFS function, step by step:

  1. Select the cell H3
  2. Type =AVERAGEIFS
  3. Double click the AVERAGEIFS command

  1. Specify the range for the average C2:C13 (the Defense values)
  2. Type ,
  3. Specify the range for the first conditionB2:B13 (the Type 1 values)
  4. Type ,
  5. Specify the criteria (the cell F3, which has the value "Grass")
  6. Type ,
  7. Specify the range for the second conditionD2:D13 (the Generation values)
  8. Type ,
  9. Specify the criteria (the cell G3, which has the value "1")
  10. Hit enter

Note: You can add more conditions by repeating steps 9-12 before hitting enter.

The function now calculates the average defense value of the 1st Generation Grass type Pokemon: Bulbasaur, Ivysaur and Venusaur.

The function can be repeated for Fire type Pokemon and 2nd Generation 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 defense values of each type between generations:

Notice how the 2nd Generation Grass type Pokemon got more defense, but the Fire type stayed the same.


Login
ADS CODE