SUMIF where CRITERIA is looking for a string occurence in the value,not the whole value

[Finny]

NOT(ISERROR(SEARCH("DLL",C1)))
is how I evaluate a single cell
I want to sum all adjacent values in 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

 

[Peo Sjoblom]

=SUMIF(C:C,"*DLL*",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)



--


Regards,


Peo Sjoblom

 

[Finny]

=SUMIF(C:C,"*DLL*",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)

--

Regards,

Peo Sjoblom

thanks! I'll try that

 

[Finny]

thanks! I'll try that

worked as expected
thank you