DEF + 甲乙丙
=SUMIFS(B1:B4,A1:A4,"*甲乙丙*",A1:A4,"*DEF*")


DEF - 甲乙丙
=SUMIF(A1:A4,"*DEF*",B1:B4)-SUMIF(A1:A4,"*甲乙丙*",B1:B4)