fx =AVERAGEIF(A1:A100,"East",B1:B100)ABCJan Score8782.3Feb Score92Mar Score78
📈 Statistical

AVERAGEIF Formula for Statistical

Average values meeting a condition. Copy-paste ready for Excel, Google Sheets, and Airtable.

=AVERAGEIF(A1:A100,"East",B1:B100)
When you need this: When you need the average sales value only for the East region (region in A1:A100, sales in B1:B100).

How it works

  1. 1Scan the criteria range (A1:A100) for matches to criterion ("East").
  2. 2Average only the corresponding values from the average range (B1:B100).
  3. 3Return the conditional average.

Variations

Average with numeric criterion
=AVERAGEIF(B1:B100,">1000",C1:C100)
AVERAGEIFS with multiple conditions
=AVERAGEIFS(C1:C100,A1:A100,"East",B1:B100,">1000")

Related Formulas

AVERAGE — Calculate the average of a rangeStatisticalCOUNTIF — Count cells that meet a conditionStatisticalCOUNTIFS — Count cells meeting multiple conditionsStatisticalMAX / MIN — Find the largest or smallest value in a rangeStatistical

Need a formula that's not here?

Generate custom formula →