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