Min If Function without Array Formula

[le_vrai_homme]

Is it possible to do a min-if function without making it an array formula?

I've got a file where I'm using a whole bunch of these and it is really slowing my file down and ballooning the size of the file.

Example of what I have:
{=MIN( IF(A1:A2=4,B1:B2,"") )}

 

[Colin Legg]

Why do you have so many of them!?

Other options might be to use a pivot table or the DMIN worksheet function?