MIN function in array formula

[Andre Croteau]

Hello,

I have created an array formula with a MAX array formula with 2 criteria,
which works fine.
However, when I change the function to MIN, I always get the result 0.

this works fine: {max((a2:a20=1)*(b2:b20=2)*c2:c20)} result gives 75

But this one doesnt:: {min((a2:a20=1)*(b2:b20=2)*c2:c20)} result gives 0,
but it should give 19

A B C
1 1 2 50
2 1 2 75
3 1 3 99
4 2 2 15
5 1 2 19
etc


Can anyone help??
Thanks in advance

André

 

[Peo Sjoblom]

Try

=MIN(IF((A2:A20=1)*(B2:B20=2),C2:C20))

 

[JE McGimpsey]

You formula *should* give 0, since multiplying FALSE (the result of
(A2:A20=1) when the value <> 1) by a value returns 0.

One way (array entered):

=MIN(IF((A1:A20=1)*(B1:B20=2),C1:C20,""))

 

[Tod]

Try this array formula instead:

=MIN(IF((A2:A20=1)*(B2:B20=2),(C2:C20),""))

tod

 

[Andre Croteau]

Thanks to all, works like a charm....

André