Google Sheets AVERAGEIF Function

AVERAGEIF Function

TheAVERAGEIF function is a premade function in Google Sheets, which calculates theaverage of a range based on atrue orfalsecondition.

It is typed=AVERAGEIF and has three parts:

Thecondition is referred to ascriterion, which can check things like:

• If a number isgreater than another number>
• If a number issmaller than another number<
• If a number or text isequal to something=

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

Example AVERAGEIF function

Find the average speed of Grass type Pokemon:

The condition is that the type is "Grass".

NameType 1Speed BulbasaurGrass45TypeAverage Speed IvysaurGrass60Grass VenusaurGrass80Fire CharmanderFire65Water CharmeleonFire80 CharizardFire100 SquirtleWater43 WartortleWater58 BlastoiseWater78

Copy Values

ExampleAVERAGEIF function, step by step:

1. Select the cellF3
2. Type=AVERAGEIF
3. Click theAVERAGEIF command

4. Specify the range for the conditionB2:B10 (the Type 1 values)
5. Type,
6. Specify the criteria (the cellE3, which has the value "Grass")
7. Type,
8. Specify the range for the averageC2:C10 (the Speed values)
9. 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: