A2中有CLCW001N,C2中有RFCCD12MIN,J2中是数据,用SUMIFS求和不成功SUMIFS(J2,A2,"CLCW001N",C2,"RFCCD12MIN"),大神们帮忙找下问题呢,谢谢!
SUMIFS
直接这样试试
sum(j2{a2='CLCW001N'&&c2='RFCCD12MIN'})