两ç§æ¹æ³å¯ä»¥å®ç°
1.ç¨countifs
=COUNTIFS($A$2:$A$6,A2,$B$2:$B$6,B2)
2.ç¨sumproduct
=SUMPRODUCT(($A$2:$A$6=A2)*($B$2:$B$6=B2))
温馨提示：答案为网友推荐，仅供参考
第1个回答 2017-09-20
=COUNTIFS(A2:A6,A2,B2:B6,B2)
相似回答
两ç§æ¹æ³å¯ä»¥å®ç°
1.ç¨countifs
=COUNTIFS($A$2:$A$6,A2,$B$2:$B$6,B2)
2.ç¨sumproduct
=SUMPRODUCT(($A$2:$A$6=A2)*($B$2:$B$6=B2))