=COUNTIFS(A1:A10,"<>"&{"CN","RJ"},B1:B10,"<>"&{"北京","重庆"})
A1:A10这个范围根据你的数据重新选择
=SUM(COUNTIFS(A:A,"<>CN",A:A,"<>RJ",B:B,{"北京","重庆"}))
=SUM(COUNTIFS(A:A,"RJ",B:B,{"北京","重庆"}))+SUM(COUNTIFS(A:A,"CN",B:B,{"北京","重庆"}))
其实=，&可以去掉
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024