Sumif and Text

  • Thread starter Thread starter Jose
  • Start date Start date
J

Jose

I'm trying to use sumif where the criteria is to match text inside a text
string. Is there an simpler way to do this and will I eventually be able
to find the right formula?
 
Assume your are searching column A for any cells that contain "Bob", summing
column B:

=SUMPRODUCT(--ISNUMBER(SEARCH("Bob",A2:A1000)),B2:B1000)
 
You're looking for the word Jose in column A and column A could have values
like:

Jose
This is Jose
This is Jose's book

and all 3 should match?

If yes, you can use a wildcard:

=sumif(a:a,"*"&"jose"&"*",b:b)
or
=sumif(a:a,"*jose*",b:b)
or even
=sumif(a:a,"*"&C1&"*",b:b)
if C1 contained Jose
 
Back
Top