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

保险工作室

=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

萬儁

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