EXCEL中多条件公式,答:I2公式:=LOOKUP(SUM(--(IF(SUMIFS($C$2:$G$8,$B$2:$F$8,$B$2:$F$8,$D$2:$H$8,"胜")>0,SUMIFS($C$2:$G$8,$B$2:$F$8,$B$2:$F$8,$D$2:$H$8,"胜"),"")<G2))/(COUNT(IF(SUMIFS($C$2:$G$8,$B$2:$F$8,$B$2:$F$8,$D$2:$H$8,"胜")>0,...
SUM和SUMIFS的嵌套公式不解,例如:=SUM(SUMIFS(C6:C14,A6:A14,A6,B6...答:因为B列的任一单元格都无法同时等于两个不同的内容 {1,3}是常量数组,意思为1和3 常量数组不能引用单元格 如果你一定要引用单元格B6,B12,则公式可以写成 =SUM(SUMIFS(C6:C14,A6:A14,A6,B6:B14,B6),SUMIFS(C6:C14,A6:A14,A6,B6:B14,B12))