FormulaCraft

AVERAGEIF

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)

Try it with your data

Edit the grid or formula, then run it through a real spreadsheet engine — no signup.

Sample data — click any cell to edit

Runs server-side · free · no signup

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

Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.

Last reviewed: