2003 & 2007


=SUMPRODUCT(($D$1:$D$2=$A2)*($R$1:$R$2=$B$2)) ... the :Rx" and "Bx" values are standard and OK.

D1 = "qwerty IHN zxcv"
D2 = "qwerty zxcv IHN"

A2 cell value = "*IHN*"

If I use =COUNTIF($D$1:$D$2,"*IHN*") the formula works as it correctly yields 2

Is there a way to make SUMPRODUCT(($D$1:$D$2=$A2)*($R$1:$R$2=$B$2)) work
(or get the same end result) if one could:

SUMPRODUCT(("*IHN*")*($R$1:$R$2=$B$2)) I know it does not work.

In short, how can I get a multi-criteria COUNTIF if "IHN" is anywhere in each cell value?

TIA EagleOne