FormulaCraft

AVERAGEIF

Average the values in a range that meet a condition.

AVERAGEIF returns the mean of cells matching a criterion — like the average order value for one customer.

Excel
=AVERAGEIF(A:A, "West", B:B)
Google Sheets
=AVERAGEIF(A:A, "West", B:B)

How it works

  1. 1A:A is tested against "West".
  2. 2Matching values in B:B are averaged.

Need a version for your data?

Try: “Average column B where the region in A is West”

Related

SUMIFSUMIFSCOUNTIF