WPS表格如何求满足条件的不重复数的个数?

2025-03-03 06:18:46
推荐回答(3个)
回答1:

公式:

=COUNT(0/FREQUENCY(ROW(A:A),MATCH(A2:A33,A2:A33,)*(B2:B32="小")*(C2:C32>60)))-1

回答2:

=countifs(b:b,"小",c:c,">60")
相同姓名的人不会被重复计算
请及时采纳答案

回答3:

=countifs(b:b,"小",c:c,">60")