'Display the minimum value based on criteria

What formula can be used to find the minimum value based on a criteria? Such as "Yes" or "No".

All help and guidance is appreciated.

https://i.imgur.com/RakaBby.png



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source