📎 This article includes 1 downloadable practice file ↓
AVERAGEIFS averages values where all conditions are true.
Syntax
=AVERAGEIFS(average_range, criteria_range1, criteria1, ...)| Argument | What it means |
|---|---|
average_range |
Cells to average. |
Examples
Example 1
=AVERAGEIFS(E:E, B:B, "North", C:C, "Retail")Average North retail order.
Common errors and fixes
| You see | Why, and the fix |
|---|---|
#DIV/0! |
No rows match. Wrap in IFERROR. |
Related functions
📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.
📎 Practice files for this article
- 📗SUMIFS/COUNTIFS scenarios workbookConditional sums and counts with dates, OR logic and wildcards, plus 4 classic reasons totals come out wrong — all with PASS/FAIL checks.⬇ XLSX · 9 KB
Free to use for learning. Files with macros (.bas) are plain text — import them with Alt+F11 → File → Import File, and always test on a copy.
✨ Ask AI about this article
Stuck on a step? Ask a question and the AI answers using this article.
Free · AI can be wrong