Finding Minimum in Range with Multiple Conditions

[bubbisthedog]

=MIN(IF('Sheet1'!$A:$A=$B4,'Sheet1'!$P:$P,""))

B4 is single condition currently. P:P is range I'm searching to find minimum value, only when A:A range includes B4 value.

I Shift+Ctrl+Enter to create array formula that finds minimum value. Now I need to add another condition for column AK:AK, and cannot figure it out.

Please help.

Thank you!!!!

 

[Eric W]

Try:

=MIN(IF('Sheet1'!$A:$A=$B4,IF('Sheet1!$AK:$AK=$X4,'Sheet1'!$P:$P,"")))

with Control+Shift+Enter.

Also, please update your user profile to show the version of Excel you're using. There's a MINIFS function in newer versions that might work for you.

 

[bubbisthedog]

Try:

=MIN(IF('Sheet1'!$A:$A=$B4,IF('Sheet1!$AK:$AK=$X4,'Sheet1'!$P:$P,"")))

with Control+Shift+Enter.

Also, please update your user profile to show the version of Excel you're using. There's a MINIFS function in newer versions that might work for you.

Wow, very fast. I love this site. Thanks so much, Eric!

I included my Excel version in profile. Don't have MINIFS() function available, unfortunately. Would be crazy simple if I had it, obviously. Hence having to go the forum route...

 

[Eric W]

Happy to help! Thanks for the update, and thanks for updating your profile.

 

[bebo021999]

Non array formula for Ex 2010+

=AGGREGATE(15,6,'Sheet1'!$P:$P/('Sheet1'!$A:$A=$B4)/('Sheet1!$AK:$AK=$X4),1)

Just enter.