EXCEL统计中COUNTIFS函数的用法答:但条件有问题:I2:I417,"=1",AJ2:AJ417,"=1",I418:I833,"=7",AJ418:AJ833,"=1",I834:I1249,"=5",AJ834:AJ1249,"=1",I1250:I1665,"=3",AJ1250:AJ1665,"=1"条件应该都在2到417行才对!即“I418:I833,"=7"”不对,应该是改为“I2:I417,"=7"”。COUNTIFS统计的必须...
excel怎样用函数统计同一个商品编号的两个等级的数?答:1、D1输入 =INDEX(A:A,SMALL(IF(MATCH(A$1:A$100&"",A$1:A$100&"",)=ROW($1:$100),ROW($1:$100),4^8),ROW(1:1)))&""数组公式,输入后先不要回车,按Ctrl+Shift+Enter结束计算,再向下填充;2、E2输入 =COUNTIFS(A:A,D2,B:B,220)回车;F2输入 =COUNTIFS(A:A,D2,B:...