| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF where CRITERIA is looking for a string occurence in the value,not the whole value
NOT(ISERROR(SEARCH("DLL",C1)))
is how I evaluate a single cell I want to sum all adjacent values in D:D if the value in C:C has DLL anywhere in the text. I know I could paste this formula in B:B and change the SUMIF to (B:B,TRUE,DD) but can I do it with a fancy SUMIF without the extra column? I am stumped and searched to no avail for this kind of question being asked in the forums. Anyone know if this is possible? I have a sense it isn't but can't find the issue directly addressed anywhere. Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SUMIF where CRITERIA is looking for a string occurence in the value, not the whole value
=SUMIF(C:C,"*DLL*",D:D)
you can use wildcards in sumif you might want to insert a space as well if DLL is separated by spaces =SUMIF(C:C,"* DLL *",D:D) -- Regards, Peo Sjoblom "Finny" wrote in message ... NOT(ISERROR(SEARCH("DLL",C1))) is how I evaluate a single cell I want to sum all adjacent values in D:D if the value in C:C has DLL anywhere in the text. I know I could paste this formula in B:B and change the SUMIF to (B:B,TRUE,DD) but can I do it with a fancy SUMIF without the extra column? I am stumped and searched to no avail for this kind of question being asked in the forums. Anyone know if this is possible? I have a sense it isn't but can't find the issue directly addressed anywhere. Thanks |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SUMIF where CRITERIA is looking for a string occurence in thevalue, not the whole value
On Aug 29, 9:38 am, "Peo Sjoblom" wrote:
=SUMIF(C:C,"*DLL*",D:D) you can use wildcards in sumif you might want to insert a space as well if DLL is separated by spaces =SUMIF(C:C,"* DLL *",D:D) -- Regards, Peo Sjoblom "Finny" wrote in message ... NOT(ISERROR(SEARCH("DLL",C1))) is how I evaluate a single cell I want to sum all adjacent values in D:D if the value in C:C has DLL anywhere in the text. I know I could paste this formula in B:B and change the SUMIF to (B:B,TRUE,DD) but can I do it with a fancy SUMIF without the extra column? I am stumped and searched to no avail for this kind of question being asked in the forums. Anyone know if this is possible? I have a sense it isn't but can't find the issue directly addressed anywhere. Thanks thanks! I'll try that |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SUMIF where CRITERIA is looking for a string occurence in thevalue, not the whole value
On Aug 30, 11:48*pm, Finny wrote:
On Aug 29, 9:38 am, "Peo Sjoblom" wrote: =SUMIF(C:C,"*DLL*",D:D) you can use wildcards in sumif you might want to insert a space as well if DLL is separated by spaces =SUMIF(C:C,"* DLL *",D:D) -- Regards, Peo Sjoblom "Finny" wrote in message .... NOT(ISERROR(SEARCH("DLL",C1))) is how I evaluate a single cell I want to sum all adjacent values in D:D if the value in C:C has DLL anywhere in the text. I know I could paste this formula in B:B and change the SUMIF to (B:B,TRUE,DD) but can I do it with a fancy SUMIF without the extra column? I am stumped and searched to no avail for this kind of question being asked in the forums. Anyone know if this is possible? I have a sense it isn't but can't find the issue directly addressed anywhere. Thanks thanks! I'll try that worked as expected thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMIF where the criteria is 'if contains a string'? | Excel Worksheet Functions | |||
| Counting Occurence of Criteria in Multiple Lists of Data | Excel Discussion (Misc queries) | |||
| formula to count occurence of criteria in 2 columns | Excel Worksheet Functions | |||
| I need to do a sumif on data that [contains] a specific string. | Excel Worksheet Functions | |||
| nested sumif or sumif with two criteria | Excel Worksheet Functions | |||
Hybrid Mode
