Sumif with cells that include a subset of text in any position

I need to sum the total count for all fashion brands contained within a set of search queries. I have managed to do with with the term at the end of the cell but it is often at the beginning or in the middle and I cannot find a way to do this.
I have attached some example data and the formula that is getting me closest so far - but is obviously not correct!
I would really appreciate any help with this.excelforum_example.xlsx

Thank you very much Ace_XL - that is perfect!!