Forum Discussion
COUNTIF/SEARCH formula with commas (Help)
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
=SUMPRODUCT(($B$2:$B$9=F$1)*(ISNUMBER(SEARCH($D2,$A$2:$A$9))))Does this return the intended result?
=SUMPRODUCT(($B$2:$B$9=F$1)*(ISNUMBER(SEARCH($D2,$A$2:$A$9))))Does this return the intended result?
