Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMPRODUCT containing txt string search
Hello all
A B Name code EN A3 LL B4 EN C2 AB B3 EN,AB A3 column A values have a name of P1B and column B has values named P1F I have the above data and Im trying to use it to count quantites of each instance of code for each 2 letter name, e.g EN has 2 instances of code A3 Im using =SUMPRODUCT((P1B="EN")*(P1F="B7")) but I cant get the formula to count when there is more than one name in a cell (eg EN,AB. I have tried using "*EN*" but doesnt work Please help! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to search a string from the right ? | Setting up and Configuration of Excel | |||
to search for a string and affect data if it finds the string? | Excel Worksheet Functions | |||
SUMPRODUCT and search string | Excel Worksheet Functions | |||
Q: search in string | Excel Discussion (Misc queries) | |||
Segregating a Search String | Excel Discussion (Misc queries) |