统计人数

noetic

见附件

noetic

不添加辅助列

蝶·舞

=COUNT(0/(MMULT(SUMIFS(J:J,C:C,UNIQUE(IF(D$3:D$72=P6,C$3:C$72)),N:N,{"An5","AN6"}),{1;1})>3500))

noetic

蝶·舞 发表于 2021-1-11 13:08
=COUNT(0/(MMULT(SUMIFS(J:J,C:C,UNIQUE(IF(D$3:D$72=P6,C$3:C$72)),N:N,{"An5","AN6"}),{1;1})>3500))

不出数啊，，，

cutecpu

=SUM(N(MMULT(SUMIFS(J:J,C:C,IF(MATCH(C$3:C$72,C:C,)=ROW($3:$72),C$3:C$72),D:D,P6,N:N,"AN"&{5,6}),{1;1})>3500))

祝順心，南無阿彌陀佛！