ExcelHeroThe AVERAGEIFS function
Averages the cells that meet several conditions.
In German Excel: MITTELWERTWENNS
How to write it
=AVERAGEIFS(average_range, criteria_range1, criteria1, [criteria_range2, criteria2], …)- average_range
- What to average (comes first!).
- criteria_range1, criteria1
- The first condition.
- criteria_range2, criteria2
- More conditions; all must be true.
💡 Same order as SUMIFS: the range to average comes first.
Try it
What is the average salary in Sales for people with 3 years or more?
A
B
C
D
1
Name
Team
Salary
Years
2
Nora
Sales
52000
3
3
Omar
Support
41000
1
4
Priya
Sales
61000
6
5
Quinn
Tech
72000
4
6
Rosa
Support
39000
2
7
Sven
Tech
80000
8
8
Sales 3+ avg
Like SUMIFS: what to average first, then the pairs.