COUNTIF/SEARCH formula with commas (Help)

[reevesgetsaround]

Hi all

I need a bit of help building on a COUNT + SEARCH formula in the attached sample doc (for range F2:K7).

I'm having a bit of trouble adding in some kind of match convention which will look at the 'Buyer' header row and break it down further.

Haven't been able to find anything online for this particular scenario.

Many Thanks

[#2 · Accepted solution]

@reevesgetsaround 

=SUMPRODUCT(($B$2:$B$9=F$1)*(ISNUMBER(SEARCH($D2,$A$2:$A$9))))

Does this return the intended result?

[#3]

@OliverScheurich 

This is perfect, thank you!