SUMPRODUCT with partial match

Copper Contributor

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 description matches in column A.  Wildcards do not work with SUMPRODUCT.
Example of a product description in column A, QTY in B and value in c
BASEPAINT ACRYLIC MATT PASTEL 5L             10             $27.00

BASEPAINT PVA MATT DEEP 5L                         5              $18.00

I tried the following formula which did not work:

The answer should be = 10x$27 = 5x$18 = $360

1 Reply




This formula works in my sheet.