總和 依业务员人數平分 (11206)

單格多人適用 H3=SUMPRODUCT((C$3:C$16/(LEN(D$3:D$16)-LEN(SUBSTITUTE(D$3:D$16,"/",))+1))*ISNUMBER(FIND(G3,D$3:D$16)))

最多可二人=SUM(SUMIF(D:D,TEXT(G3,{"!*@!*","@"}),C:C))/2