| 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 |
| 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 | |||
Threaded Mode
