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.

CodePudding user response：

If your version of Excel supports MINIFS:

=MINIFS(B2:B5,C2:C5,"Yes")

Otherwise:

=MIN(IF((C2:C5="Yes")*(B2:B5<>""),B2:B5))