Try using the CountIf function. Assuming your range is copied to A3:A8, it would look like the below; anything starting with bloggs. If you needed to, you could put another wildcard "*" at the beginning of the search string.
=COUNTIF(A3:A8,"bloggs*")
HTH
Martin