图1
在单元格H2中的公式为:
=MIN(SUMIFS(F2:F13,A2:A13,{"Mike","John","Alison"},B2:B13,"A",C2:C13,"B",D2:D13,"C",E2...公式的中间结果为:
=MIN({5,0,4})
结果为:
0
然而,如果想要得到除0以外的最小值,一般会使用下面的公式:
=MIN(IF(SUMIFS(F2:F13,A2:A13,{"Mike","John...A",C2:C13,"B",D2:D13,"C",E2:E13,">="&DATEVALUE("2019/8/27"),E2:E13,"0,SUMIFS...其实可以使用含有IFERROR函数的公式来简化:
=MIN(IFERROR(1/(1/(SUMIFS(F2:F13,A2:A13,{"Mike","John","Alison"},B2:B13,"A",...还有一个示例:
=MIN(IFERROR(POWER(SQRT(A1:A10),2),""))
与下面的公式结果相同:
=MIN(IF(A1:A10>=0,A1:A10))
返回单元格A1:A10中除负数以外的值中的最小值