=SUMIFS(H$4:H$44,$D$4:$D$44,"<>"&"当期新增"),其中"<>"&"当期新增...答:excel带条件求和。"<>"&"当期新增" 表示 对D列不等于“当期新增”的H行数据求和。语法 SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)=SUMIFS(A2:A9,B2:B9,"=A*",C2:C9,"卢宁")=SUMIFS(A2:A9,B2:B9,"<>香蕉",C2:C9,"卢宁")...