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