保险工作室 发表于 2022-1-1 16:46:37

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

乄娚亼 发表于 2022-1-2 00:40:44

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

农祥格 发表于 2022-1-3 19:13:23

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

深谷君兰 发表于 2022-1-13 17:23:28

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

东东哥懂我 发表于 2022-1-16 12:01:16

=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)))

这颗心稀巴烂 发表于 2022-1-28 21:20:54

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

数组下拉

之之 发表于 2022-2-2 01:58:46

非数字，应该不能用frequency

萬儁 发表于 2022-2-4 20:59:37

谢谢你，刚刚试了一下没有问题
页: 1 2 [3]
查看完整版本: 怎么统计对应人名的工作天数