MINIFS

[wizardmagu]

I am trying to find the Minimum number based on criteria of another cell. The catch is I only want to know if the value is greater than 1.

In this example I want the result from the formula to be 20. Thoughts?
=MINIFS($B$2:$B$7,$A$2:$A$7,D1)

 

[Fluff]

How about

=MINIFS($B$2:$B$7,$B$2:$B$7,">1",$A$2:$A$7,D1)

 

[wizardmagu]

thank you very much!

 

[Fluff]

You're welcome & thanks for the feedback.

 

[wizardmagu]

Looking at the differences between the formula I had and the one you provided. Looks like the one that you provided uses a more "traditional IF statement" that states when true and when false.... which allows for the >1.