陈映丰 发表于 2021-12-6 12:26:22

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

天外侠客 发表于 2021-12-8 14:55:27

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

榭雨忧蓝 发表于 2021-12-15 05:06:50

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

多余的我 发表于 2021-12-17 21:27:33

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

天线技术 发表于 2021-12-20 00:22:56

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

自由的橡树 发表于 2021-12-21 14:48:34

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

万树藤 发表于 2021-12-23 08:37:28

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

数组下拉

陈奎名 发表于 2021-12-25 14:44:29

非数字，应该不能用frequency

武汉市 发表于 2021-12-29 08:23:34

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

叶琦亮 发表于 2021-12-31 17:32:15

=SUMPRODUCT(1/COUNTIFS(B$2:B$30,B$2:B$30,C$2:C$30,C$2:C$30)*(B$2:B$30=G2))
页: 1 [2] 3
查看完整版本: 怎么统计对应人名的工作天数