excel用什么函数求一列数据中满足条件的对应数据的和答:用公式:=SUMIFS(C:C,A:A,"11515154480",B:B,"浅花灰")+SUMIFS(C:C,A:A,"11515154480",B:B,"土耳其蓝")+SUMIFS(C:C,A:A,"11215103205",B:B,"墨水蓝")+SUMIFS(C:C,A:A,"11215157111",B:B,"浅花灰")如果A列数据为数值类型,把引用去掉。
excel表格中用公式求满足条件的单元格的和答:在E1输入以下公式,然后向下填充公式 =IF(B1="","",ROUND(C1+D1,0))在F1输入以下公式,然后向下填充公式 =IF(COUNTA(B1:D1)="","",IF(AND(B1="",OR(C1<>"",D1<>"")),"缺名字",IF(AND(B1<>"",D1=""),"未考试")))...