Skip to content
Home
Tutorials
Real-World Examples
Count cells that contain text
Update Formula
Parameters
Formula
Range Reference:
enter the range from which you want to count the number of cells that contain text
Formula:
=
COUNTIF
(
B5:B9
,"*")
=
COUNTIF
(B5:B9,"*")