Counting strings when may be 2 strings in a cell

I want to count the number of times a particular string appears in a worksheet and place the result in another cell. Sometimes the same string appears in a cell 2 times and I want to count this instance twice (I am counting teams in a sporting fixture and sometimes teams from the same clubs play each other – eg SaintsDX vs SaintsMT)

I have tried Countif but this only counts the number of cells containing the string and does not account for cases where the string appears twice in a cell. The only thing I have found that counts the string twice if it appears twice in a cell is Find and Replace. However, I also want to capture the result and cut and paste it into another cell - doing Find and Replace I can only see the number of instances of it and then type into another field.

Any ideas? Ideally I am looking for a manual way to do this (like Find and Replace) which I can record into a macro.

I have attached a workbook with an example and desired result

I tried an attachment but not sure if it worked - let me know if not and will try again.

In the attachment, in cell D8 there are 2 Rupertwood teams which I need to be counted as 2 finds and in E10 there are 2 Rebel teams.

Thanks

I think attachment worked this time