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

J

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 !
 
D

Domenic

Try...

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

Adjust the ranges accordingly.

Hope this helps!
 
Top