有没有公式
=SUM(IF(ISNUMBER(FIND(E2,$A$2:$A$3)),$B$2:$B$3,0)/(LEN($A$2:$A$3)-LEN(SUBSTITUTE($A$2:$A$3," ",""))+1))
CTRL+SHIFT+回车
如上图,E2=SUMPRODUCT(IFERROR(FIND(D2,$A$2:$A$5)>0,0)*($B$2:$B$5/(LEN($A$2:$A$5)-LEN(SUBSTITUTE($A$2:$A$5," ",""))+1))),同时按下CTRL+SHIFT+回车形成数组公式,之后公式下拉自动填充。