ExcelHeroThe COUNTIF function
Counts the cells that meet a condition.
In German Excel: ZÄHLENWENN
How to write it
=COUNTIF(range, criteria)- range
- Where to look.
- criteria
- What to count, like "Pro" or ">=60".
💡 Text conditions are not case-sensitive.
Try it
How many sales happened in the North?
A
B
C
D
1
Region
Rep
Product
Amount
2
North
Maya
Laptop
1200
3
South
Leo
Phone
650
4
North
Leo
Phone
700
5
West
Maya
Tablet
480
6
North
Sam
Laptop
1100
7
South
Sam
Tablet
520
8
North sales
Count "North" in the Region column.