I am using this formula:

=MIN(IF($A$1:$A$7=D1,$B$1:$B$7))

I wouldlike to modify it to perform the calculation if E1:E7="Check"

Thank you in advance.