用SUMPRODUCT函数试试E1=SUMPRODUCT((ISNUMBER(FIND(D1,A$1:A$100)))*B$1:B$100)下拉
去掉公式第二参数的""&，D2&"*"表示以D2内容开头
=SUMIF(A:A,D2&"*",B:B)或=SUMIF(A:A,"*"&D2&"*",B:B)
=SUMIF(A:A,SUBSTITUTE(D1,"*","~*")&"*",B:B)
