I have a sumproduct function with two criteria, one of which is only one word of cells that contain several words. I have tried using wildcards but the result is 0. I have also tried a countif in the second criteria, still to no avail.

Any suggestions would be greatly appreciated.

Thank you.