Min/max with criteria

[syban]

Hello, I am using an averageif to calculate the average of the prices that a company bought boxes of aluminium. I am using the following function and excel calculates the average price of aluminium buys only (the data is in different page and the function is on another sheet called results)
=AVERAGEIF('SHEET A'!F2:F14;"ALUMINIUM";'SHEET A'!K2:K14)

I am having problem with doing the same thing with min and max function. I want excel to find the minimum and maximum price of aluminium buys only.

I would appreciate the help because this is for my work.

Sincerely yours
Syban

 

[etaf]

=MIN(IF(('SHEET A'!$F$2:$F$14="ALUMINIUM")*('SHEET A'!$K$2:$K$14<>""),'SHEET A'!$K$2:$K$14))
use control shift enter to get an Array
{=MIN(IF(('SHEET A'!$F$2:$F$14="ALUMINIUM")*('SHEET A'!$K$2:$K$14<>""),'SHEET A'!$K$2:$K$14))}

for MAX
{=MAX(IF(('SHEET A'!$F$2:$F$14="ALUMINIUM"),'SHEET A'!$K$2:$K$14))}

 

[syban]

=MIN(IF(('SHEET A'!$F$2:$F$14="ALUMINIUM")*('SHEET A'!$K$2:$K$14<>""),'SHEET A'!$K$2:$K$14))
use control shift enter to get an Array
{=MIN(IF(('SHEET A'!$F$2:$F$14="ALUMINIUM")*('SHEET A'!$K$2:$K$14<>""),'SHEET A'!$K$2:$K$14))}

for MAX
{=MAX(IF(('SHEET A'!$F$2:$F$14="ALUMINIUM"),'SHEET A'!$K$2:$K$14))}

Thank you very much etaf! lifesaver...!Very helpful!!!!

 

[syban]

Oops sorry mate....I just noticed that this calculates the min and max of the entire column....not only by the ones belonging to Aluminium buys....

 

[syban]

Never mind!!!! PC problem!!!! Its ok now! sorry

 

[etaf]

Your are welcome