Skip to content
Home
Tutorials
Real-World Examples
Count cells if begins with
Update Formula
Parameters
Formula
Range Reference:
Cell Reference of specific value:
enter the cell reference that captures the value that you want to count for if a cell begins with this value
Formula:
=
COUNTIF
(
B8:B14
,
C5
&"*")
=
COUNTIF
(B8:B14,C5&"*")