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

[Johnny M]

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 !

 

[Domenic]

Try...

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

Adjust the ranges accordingly.

Hope this helps!

 

[Toppers]

try:

=SUMIF(C1:C3,"=*E50*",D13)

HTH

 

[Johnny M]

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

Many thanks