Modify A Formula To Include AND

[Guest]

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.

 

[Aladin Akyurek]

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)))

 

[Bob Phillips]

I think you mean

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

as an array formula

--

HTH

RP
(remove nothere from the email address if mailing direct)