E
EagleOne
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
=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