ExcelHeroThe COUNTIFS function
Counts the rows that meet several conditions.
In German Excel: ZÄHLENWENNS
How to write it
=COUNTIFS(range1, criteria1, [range2, criteria2], …)- range1, criteria1
- The first condition.
- range2, criteria2
- More conditions; all must be true.
💡 All ranges must be the same size.
Try it
How many people in Sales earn more than 50,000?
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
Count
COUNTIFS: range, condition, range, condition.