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 !