ExcelHeroThe COUNTA function
Counts the cells that are not empty.
In German Excel: ANZAHL2
How to write it
=COUNTA(value1, [value2], …)- value1
- A range to count filled cells in.
💡 A cell with a formula that returns "" still counts as filled.
Try it
How many people signed up?
A
B
C
1
Name
Email
Plan
2
Lena
Pro
3
Tom
Free
4
Ivy
Free
5
Max
Pro
6
Zoe
Free
7
8
Signups
Names are text, so COUNT won’t see them. Try COUNTA.