Count cells that contain a specific value

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&"*")