具有范围标准的MIN IF公式（后续）(MIN IF formula with range criteria (follow

具有范围标准的MIN IF公式（后续）(MIN IF formula with range criteria (follow-up))

这个问题是这个主题的后续问题： 带有范围标准的MAX IF公式

在这种情况下，我需要找到最小值，但看起来公式看起来与上面帖子中的MAX变化看起来完全不同。 在这种情况下，应跳过空白单元格，结果为5％（E7）。 你能帮帮我这个吗？ 谢谢！

This question is a follow-up of this thread: MAX IF formula with range criteria

In this case I need to find min value, but it seems that the formula will look quite different than in MAX variation in the post above. In this scenario blank cells should be skipped and the result would be 5% (E7). Could you help me with this one? Thanks!

最满意答案

=AGGREGATE(15,6,($E$4:$E$15/((E4:E15<>"")*($B$4:$B$15=$G5)*($C$4:$C$15=$H5)*(($D$4:$D$15=$G$8)+($D$4:$D$15=$G$9)+($D$4:$D$15=$G$10)))),1)

概念证明

=AGGREGATE(15,6,($E$4:$E$15/((E4:E15<>"")*($B$4:$B$15=$G5)*($C$4:$C$15=$H5)*(($D$4:$D$15=$G$8)+($D$4:$D$15=$G$9)+($D$4:$D$15=$G$10)))),1)

Proof of Concept