Skip to content
Home
Tutorials
Real-World Examples
Count cells that contain a specific value
Update Formula
Parameters
Formula
Range Reference:
Cell Reference:
enter the cell reference that contains the value that you want to count for:
Formula:
=
COUNTIF
(
B5:B7
,"*"&
D5
&"*")
=
COUNTIF
(B5:B7,"*"&D5&"*")