ExcelHeroThe COUNTBLANK function
Counts the empty cells in a range.
In German Excel: ANZAHLLEEREZELLEN
How to write it
=COUNTBLANK(range)- range
- The range to check.
💡 Handy for finding missing data in a list.
Try it
How many people did not leave an email?
A
B
C
1
Name
Email
Plan
2
Lena
Pro
3
Tom
Free
4
Ivy
Free
5
Max
Pro
6
Zoe
Free
7
8
No email
There is a function made for empty cells.