0

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!

Improve this question

1 Answer 1

Reset to default
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

Proof of Concept

Improve this answer
Sign up to request clarification or add additional context in comments.

3 Comments

This is great, worked perfectly! Thank you once again
@micxid If this answered your question you should mark it, so that future readers will notice that (and the answerer will gain rep)
@JBrazier you forgot to mention that micxid will also gain rep for awarding answers (not sure about upvoting) which will in turn allow micxid to have more privileges on the site

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.