# How to average with multiple criteria in Excel (AVERAGEIFS)

Use AVERAGEIFS with the range to average first and one pair per condition: `=AVERAGEIFS(D2:D9,B2:B9,G1,C2:C9,">="&G2)`.

**Excel:** `=AVERAGEIFS(D2:D9,B2:B9,G1,C2:C9,">="&G2)` (Every current version)

**Google Sheets:** the same formula works.

## Example

Sample data (row 1 is the header):

| A | B | C | D | E | F | G |
| --- | --- | --- | --- | --- | --- | --- |
| Address | Neighborhood | Beds | Price |  | Neighborhood | Linden |
| 12 Oak St | Linden | 3 | 412000 |  | Min beds | 3 |
| 48 Elm Ave | Harbor | 2 | 298000 |  | Average price |  |
| 7 Pine Ct | Linden | 4 | 535000 |  |  |  |
| 91 Birch Rd | Linden | 2 | 345000 |  |  |  |
| 33 Cedar Ln | Harbor | 3 | 389000 |  |  |  |
| 5 Maple Dr | Linden | 3 | 447500 |  |  |  |
| 60 Ash Way | Harbor | 4 | 468000 |  |  |  |
| 18 Spruce St | Linden | 5 | 612000 |  |  |  |

Formula in G3: `=AVERAGEIFS(D2:D9,B2:B9,G1,C2:C9,">="&G2)`

Result: $501,625

## How it works

AVERAGEIFS averages a row only when every condition is true: the neighborhood must be Linden **and** the bedrooms at least 3. Four homes qualify, and their prices average to $501,625. The two-bedroom Linden home is left out.

## Other ways

- `=AVERAGE(FILTER(D2:D9,(B2:B9=G1)*(C2:C9>=G2)))`: Excel 365 and Google Sheets: FILTER keeps the matching prices, and you can see them by removing AVERAGE.

## Common mistakes

- Every range must be the same size as the average range, or AVERAGEIFS returns #VALUE!.
- The comparison needs quotes: `">="&G2`, not `>=G2`.

## Questions

**How do I average between two values?**

Use two conditions on the same column: `=AVERAGEIFS(D2:D9,C2:C9,">=3",C2:C9,"<=4")`.

**How do I use OR, like Linden or Harbor?**

AVERAGEIFS can't; use FILTER with + : `=AVERAGE(FILTER(D2:D9,(B2:B9="Linden")+(B2:B9="Harbor")))`.

Every formula and result on this page was checked by running it in the Spreadsheet Practice formula engine on 2026-10-30.

Source: https://spreadsheetpractice.com/formulas/averageifs-average-with-multiple-criteria