Formula guide · Excel and Google Sheets · Updated May 13, 2026
AVERAGEIFS Formula
Use AVERAGEIFS to calculate an average only for rows that match your criteria.
Quick Answer
AVERAGEIFS filters rows by criteria first, then averages the matching numeric values.
Copyable Formula
=AVERAGEIFS(D2:D20,B2:B20,"West",C2:C20,"Paid")Syntax
=AVERAGEIFS(average_range, criteria_range1, criteria1, ...)Excel and Google Sheets
Worked Example
| B | C | D |
|---|---|---|
| Region | Status | Score |
| West | Paid | 82 |
| West | Paid | 91 |
| East | Paid | 77 |
Result: Returns the average of West/Paid scores: 86.5.
Steps
- Select the numeric values to average.
- Add criteria ranges and criteria pairs.
- Check whether blank or text values should be excluded.
Common Mistakes
- Averaging percentages without checking whether they are stored as numbers.
- Using ranges with different sizes.
- Forgetting that empty matching sets can return an error.
Excel vs Google Sheets Notes
The core idea works in both Excel and Google Sheets, but separators, function availability, and array behavior can vary by account, locale, and version.
Editorial check: This guide was last updated May 13, 2026. Formula behavior can vary by Excel version, Google Sheets rollout, and spreadsheet locale.