ExcelHeroThe AVERAGEIF function
Averages the cells that meet a condition.
In German Excel: MITTELWERTWENN
How to write it
=AVERAGEIF(range, criteria, [average_range])- range
- Where to check the condition.
- criteria
- What to look for.
- average_range
- Optional. What to average.
💡 If nothing matches you get #DIV/0!. Wrap it in IFERROR.
Try it
What is the average salary in Support?
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
Support avg
Where to look, what to look for, what to average.