SOLVED

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)
Solution

@reevesgetsaround 

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

Does this return the intended result?

sumproduct.JPG

@OliverScheurich 

 

This is perfect, thank you!

 

 

1 best response

Accepted Solutions
best response confirmed by reevesgetsaround (Brass Contributor)
Solution

@reevesgetsaround 

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

Does this return the intended result?

sumproduct.JPG

View solution in original post