怎么统计对应人名的工作天数

陈映丰

=SUMPRODUCT(1/COUNTIFS(B$2:B$30,B$2:B$30,C$2:C$30,C$2:C$30)*(B$2:B$30=G2))

天外侠客

=COUNT(0/FREQUENCY(($B$2:$B$30=G2)*($C$2:$C$30),($B$2:$B$30=G2)*($C$2:$C$30)))-1

榭雨忧蓝

=SUMPRODUCT(($B$2:$B$30=G2)/COUNTIFS($B$2:$B$30,$B$2:$B$30,$C$2:$C$30,$C$2:$C$30))

多余的我

=COUNT(0/(MATCH(G2&$C$2:$C$30,$B$2:$B$30&$C$2:$C$30,)=ROW($1:$29)))

天线技术

动态区域。
数组公式：=COUNT(0/(MATCH(G2&OFFSET(C$2,,,COUNTA(B:B)-1),B:B&C:C,)=ROW(OFFSET(C$2,,,COUNTA(B:B)-1))))

自由的橡树

=SUMPRODUCT(($B$2:$B$30=G2)*(MATCH($B$2:$B$30&$C$2:$C$30,$B$2:$B$30&$C$2:$C$30,)=ROW($1:$29)))

万树藤

=SUM(($B$2:$B$30=G2)/COUNTIFS($C$2:$C$30,$C$2:$C$30,$B$2:$B$30,$B$2:$B$30))

数组下拉

陈奎名

非数字，应该不能用frequency

武汉市

谢谢你，刚刚试了一下没有问题

叶琦亮

=SUMPRODUCT(1/COUNTIFS(B$2:B$30,B$2:B$30,C$2:C$30,C$2:C$30)*(B$2:B$30=G2))