One way:

=SUMIF(A:A,"*-XYZ-*",B:B)

In article .com,
wrote:

I have a worksheet where the first column contains a special code
specific to each product we sell, containing a code for 1) the
territory where it's sold; 2) the vendor; 3) the product name; etc. I
am trying to figure out a way to create a sumif formula (or other
formula if necessary) to only sum, for example, values where the
vendor is XYZ. Here's an example:

C-SRS-INC-ARBYS-5 50
C-SRS-SLF-TESTY-1 75
C-SRS-INC-CRASHY-3
C-SRS-TMN-TESTY-3
C-SRS-TMN-TESTY-4