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