Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUMPRODUCT() challenge - How to integrate a string value in lieu of a value in a cell .....
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUMPRODUCT() challenge - How to integrate a string value in lieu of a value in a cell .....
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUMPRODUCT() challenge - How to integrate a string value in lieu of a value in a cell .....
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMPRODUCT containing txt string search | Excel Worksheet Functions | |||
SUMPRODUCT formula challenge | Excel Worksheet Functions | |||
Sumproduct - Return a String | Excel Discussion (Misc queries) | |||
SUMPRODUCT and search string | Excel Worksheet Functions | |||
What does a "plus" cursor mean (in lieu of the pointer?)? thanks | Excel Worksheet Functions |