Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help on sumproduct() - sum by searching for a common sub string in
Hi
Can anyone help me on this. thanks in advance. I am getting answer required by the following formula =SUMPRODUCT(--(DREGION="HQ BLNG EAST")+(DREGION="HQ BLNG WEST")+(DREGION="HQ BLNG NORTH")+(DREGION="HQ BLNG SOUTH"),MISDUE) Where the first part is constant "HQ BLNG". Is there any way to search the string in range DREGION and find the sum. Like "HQ BLNG xxxx", "xxxx TRANSPORT xxxx", "xxxxx xxxxx FREIGHT" xxxx i mean to say that it could be any string. Thank you |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Most common occurrence of a string | Excel Worksheet Functions | |||
Formula for searching for a text string | Excel Discussion (Misc queries) | |||
Searching a text string in a range of cells. | Excel Worksheet Functions | |||
Searching for string in other cells | Excel Worksheet Functions | |||
searching and summing using string within cell | Excel Discussion (Misc queries) |