总数 员工字符不一致 (9565)

B11{=SUM(N(MMULT(1-ISERR(FIND(TRANSPOSE(E2:E8),A2:A99)),ROW(1:7)^0)=1+COUNTIF(E2:E8,""))*B2:B99)

另解=SUMPRODUCT(SUMIF(A:A,E2:E8&"*",B:B)*(E2:E8<>""))