COUNTIF/SEARCH formula with commas (Help)

Brass Contributor

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 Replies
best response confirmed by reevesgetsaround (Brass Contributor)



Does this return the intended result?




This is perfect, thank you!