EXCEL 将A列相同的合并,对应B列的数值求和答:假设原表为SHEET1表,在SHEET2表的A1输入:=index(sheet1!a:a,small(if(match(sheet1!a$1:a$100&"",sheet1!a$1:a$100&"",)=row($1:$100),row($1:$100),4^8),row(a1)))&""数组公式,按ctrl+shift+enter结束 下拉填充 在sheet2表的b2输入:=sumif(sheet1!a:a,a2,sheet1!b:...
EXCEL中怎样合并内容相同的单元格同时数值求和答:在C1输入:=IF(ISERROR(INDEX(A:A,SMALL(IF(MATCH($A$1:$A$4,$A$1:$A$4,)=ROW($1:$4),ROW($1:$4),65536),ROW(A1)))&""),"",INDEX(A:A,SMALL(IF(MATCH($A$1:$A$4,$A$1:$A$4,)=ROW($1:$4),ROW($1:$4),65536),ROW(A1)))&"")按CTRL+SHIFT+ENTER数组形式...