Counting specific value when various are within cell?

Dear all,

I have attached an example for you.

In cell F4 you will see I have a formula to count all the 'Gary Stoddard's in column b only if column A has the number "4" in it. What I am noticing this formula is only pulling the Gary Stoddards that are in a cell on its own and not where there are other names mentioned?

How do I write this formula so it captures all mentions of Gary Stoddard?

Thank you so much in advance.

Jodie

=COUNTIFS(B:B,"*Gary Stoddard*",A:A,"4)

or
=COUNTIFS(B:B,"*"&b5&"*",A:A,"4")

It won't count b4 as 4 but as 1 but assume this is what you want

That's great thank you so much.