Unlear what you exactly intend to modify to the formula you post...

Maybe:

(a)

=MIN(IF($E$1:$E$7="Check",$B$1:$B$7))

(b)

=MIN(IF($A$1:$A$7=D1,IF(E1:E7="Check",$B$1:$B$7)))

carl wrote:
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.