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 l...
=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?
