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数组形式...