excel中 A列相同日期,B列相同名称,将对应C列数据求和,最后将A、B列相 ...答:在F2中输入:=IF(COUNTIF(F$1:F1,A2)<1,A2,IF(COUNTIF(B$2:B2,B2)<2,A2,""))在G2中输入:=IF(COUNTIF(B$2:B2,B2)<2,B2,IF(F2=A2,B2,""))在H2中输入:{=IF(H2="","",SUM(IF(A$2:A$13=A2,1)*IF(B$2:B$13=B2,1)*C$2:C$13))}(注:这个要同时按SHIFT+...