合併格平分獎金 計算總獎金 (14311)

F2=IF(C2="",F1,-LOOKUP(1,-E$2:E2)/-LOOKUP(1,-MATCH(1=1,C3:C$13<>"",{1,0})))

H2=SUMPRODUCT((D$2:D$12=G2)*F$2:F$12)

I2{=SUM(LOOKUP(ROW(2:12),ROW(2:12)/(E$2:E$12<>""),E$2:E$12)/MMULT(N(COUNTIF(OFFSET(C$2,,,ROW($1:$11)),"<>")=TRANSPOSE(COUNTIF(OFFSET(C$2,,,ROW($1:$11)),"<>"))),ROW(2:12)^0)*(D$2:D$12=G2))