Count cells if ends with

Range Reference:
Cell Reference of specific value:
enter the cell reference that captures the value that you want to count for if a cell ends with this value
Formula:

=COUNTIF(B8:B14,"*"&C5)
=COUNTIF(B8:B14,"*"&C5)