Hi all

=SUMPRODUCT((--Data!$a$2:$a$5000=11)*(--Data!$a$2:$a$5000<=50),--ISNUMBER(SEARCH("taps",Data!b2:b5001)))

Column A contains quantity
Column B contains commodities

I need to know how many instances we have sold quantities between 11-50 of any commodity which contains the word taps (the cells do contain other text). My attempt is above but It doesn't work. Please advise what I am doing wrong?