C2公式下拉:
=IF(B2="","",LEN(B2)-LEN(SUBSTITUTE(B2," ",))+1)
D2公式下拉:
=IF(B2="","",SUMPRODUCT(ISNUMBER(0/(FIND(Sheet2!A$2:A$999,B2)*(Sheet2!A$2:A$999<>"")))*OFFSET(Sheet2!A$2,,MATCH(A2,Sheet2!$1:$1,)-1,998)))