Sumif text is contained winthin a longer text string in a cell
 

Hi
I am trying to do a sumif to look up on cells containing text as opposed to
being exactly equal. For example, I have a cell containing the text
NKE50Q-WH and want a formula that finds that cell in a sumif based on it
containg the text E50 only.
Any ideas much appreciated !

Sumif text is contained winthin a longer text string in a cell
 

Try...

=SUMIF(A2:A100,"*E50*",B2:B100)

Adjust the ranges accordingly.

Hope this helps!

In article ,
Johnny M wrote:

Hi
I am trying to do a sumif to look up on cells containing text as opposed to
being exactly equal. For example, I have a cell containing the text
NKE50Q-WH and want a formula that finds that cell in a sumif based on it
containg the text E50 only.
Any ideas much appreciated !

Sumif text is contained winthin a longer text string in a cell
 

try:

=SUMIF(C1:C3,"=*E50*",D1:D3)

HTH

"Johnny M" wrote:

Hi
I am trying to do a sumif to look up on cells containing text as opposed to
being exactly equal. For example, I have a cell containing the text
NKE50Q-WH and want a formula that finds that cell in a sumif based on it
containg the text E50 only.
Any ideas much appreciated !

Sumif text is contained winthin a longer text string in a cell
 

Brilliant ! Thought it would be something simple....

Many thanks

"Toppers" wrote:

try:

=SUMIF(C1:C3,"=*E50*",D1:D3)

HTH

"Johnny M" wrote:

Hi
I am trying to do a sumif to look up on cells containing text as opposed to
being exactly equal. For example, I have a cell containing the text
NKE50Q-WH and want a formula that finds that cell in a sumif based on it
containg the text E50 only.
Any ideas much appreciated !