Sumif and Text
 

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?
--
I need so much help, but right now, some Excel help will suffice!!

Sumif and Text
 

Assume your are searching column A for any cells that contain "Bob", summing
column B:

=SUMPRODUCT(--ISNUMBER(SEARCH("Bob",A2:A1000)),B2:B1000)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Jose" wrote:

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?
--
I need so much help, but right now, some Excel help will suffice!!

Sumif and Text
 

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



Jose wrote:

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?
--
I need so much help, but right now, some Excel help will suffice!!

--

Dave Peterson