请问如何用excel公式实现双条件求和?答:用 if 函数设置公式如下:=IF(J4>7000,3000,IF(J4>=5000,2000,IF(J4>=3000,1000,"未设置小于3000的规则")))也可以用 vlookup 函数设置 =VLOOKUP(J4,{3000,1000;5000,2000;7000.001,2000;3000,5000},2,TRUE)
EXCEL表IF多条件求和??答:输入以下公式 =SUMIFS(C:C,B:B,"长",C:C,">7000")*0.2+SUMIFS(C:C,B:B,"长",C:C,"<7000")*0.1+SUMIFS(C:C,B:B,"短",C:C,">13000")*0.3+SUMIFS(C:C,B:B,"短",C:C,"<13000")*0.25