How to average with multiple criteria (AVERAGEIFS)
✓ Verified in LibreOffice 25.8.7.3Average only the rows that meet several conditions at once.
The formula
| App | Formula | Notes |
|---|---|---|
| Excel | =AVERAGEIFS(B2:B6,A2:A6,"East",B2:B6,">100") | Average range first, then range/criteria pairs. |
| Google Sheets | =AVERAGEIFS(B2:B6,A2:A6,"East",B2:B6,">100") | Identical. |
| LibreOffice Calc | =AVERAGEIFS(B2:B6,A2:A6,"East",B2:B6,">100") | Identical. |
How it works
AVERAGEIFS works like SUMIFS: the range to average comes first, followed by condition pairs that are ANDed together. Of the "East" rows (150, 80, 200), only 150 and 200 pass the >100 test, and their average is 175. If no rows match all conditions it returns #DIV/0! — wrap in IFERROR if that's expected.
Verified, not just documented
We ran =AVERAGEIFS(B2:B6,A2:A6,"East",B2:B6,">100") in LibreOffice 25.8.7.3 (headless, with forced recalculation) and it returned 175 — exactly the expected result. Every formula here is confirmed by actually executing it.