Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
AVERAGEIFS
AVERAGEIFS extends AVERAGEIF to multiple criteria — average amounts that match a region AND a date range, for example.
Excel
=AVERAGEIFS(C:C, A:A, "West", B:B, ">100")Google Sheets
=AVERAGEIFS(C:C, A:A, "West", B:B, ">100")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
- 1C:C is the range whose matching values are averaged.
- 2A:A = "West" is the first condition.
- 3B:B > 100 is the second condition; only rows matching both are averaged.
Need a version for your data?
Try: “Average column C where region in A is West and amount in B is over 100”