MINIFS Function

I am trying to find a MIN IF using the array function.

{=MIN(IF($C$2:$C$30=I$7,$F$2:$F$30))} - this seems to work in I10, but it doesn’t seem like the intended MINIFS function.

Having issues with MINIFS and correct coding. In cell I10 I am not able to drag the formula to J10 as it brings up error 508 for both cells. Also, I tried the below in J10 and it brings up error 511.

{=MINIFS($C$2:$C$30=J$7,$F$2:$F$30)}
Array+Functions.xlsx

From the Help of the Calc:

Syntax

MINIFS(Func_Range; Range1;Criterion1 [ ; Range2; Criterion2 [;…]]))

There is not third parameter in the formula of your sample file. (The Error code 511 means: Missing parameter.)

Try this:

=MINIFS($F$2:$F$30;$C$2:$C$30;"="&J$7)

And use the native, international standard ODF file formats.

1 Like

It is enough =MINIFS($F$2:$F$30;$C$2:$C$30;J$7).

Thank you. Yes, it is enough for the “equals” relation. My sample shows (not intentionally), how you can use other relations (<, >=, <>) with the value of the cell J$7.