Forum Discussion
SUMPRODUCT with partial match
In column A I have a list of product descriptions. In column B I have the quantity of items and in column C I have the values of the items. I would like to multiply B and C where a partial descript...
=SUMPRODUCT(ISNUMBER(SEARCH("MATT",A1:A10))*ISNUMBER(SEARCH("5L",A1:A10))*(B1:B10)*(C1:C10))
This formula works in my sheet.