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

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

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

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