计算每人每天开的不重复机台数 (9522)

F2:H6=SUMPRODUCT(($A$2:$A$16=F$1)*($B$2:$B$16=$E2)/COUNTIFS($A:$A,$A$2:$A$16,$B:$B,$B$2:$B$16,$C:$C,$C$2:$C$16))

另解{=SUM(IFERROR(($A$2:$A$16=F$1)*($B$2:$B$16=$E2)/COUNTIFS($A:$A,F$1,$B:$B,$E2,$C:$C,$C$2:$C$16),))