Thread: Sumif text is contained winthin a longer text string in a cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Johnny M[_2_] Johnny M[_2_] is offline
external usenet poster
  
Posts: 7
Default 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 !
Reply With QuoteReply With Quote