CODEWITHSUNDEEP
excelexcel-formula
micxid
micxid

Reputation: 25

MIN IF formula with range criteria (follow-up)

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!

Upvotes: 0

Views: 78

Answers (1)

Forward Ed
Forward Ed

Reputation: 9894

=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

Proof of Concept

Upvotes: 1

Related Questions