Minimum With Criteria - Urgent

[will2learn]

I have two columns of numbers H and L, some cells in column H are empty. I'm trying to obtain the minimum number from column L where there is a value in column H.

I've tried using this array formula without any luck.

{=MIN(IF(H20:H1000>0,L20:L1000))}

Can anyone assist?

 

[Yahya]

i don't see any problem in your Formula
it is working for me with empty cells and it is ignore empty
could you give sample data with the problem and what is the expected result ?