Problem with Array and MIN function

[Campbell]

I want to find the minimum numerical value in column E based on the
text value of column D. The range of the data is D3:E40, however the
D340 is complete, but E3:E6 has data but E7 to E40 are blank and
will have values as they are completed. The formula used is
{=MIN(IF(D340=AA2,E3:E40))} returns 0 but
{=MIN(IF(D36=AA2,E3:E6))} returns the actual value.
AA2 is a text value.

What am I doing wrong?

 

[Frank Kabel]

Hi
try:
{=MIN(IF((D340=AA2)*(E3:E40<>""),E3:E40))}

 

[Campbell]

=MIN(IF((D340=AA2)*(E3:E40<>""),E3:E40))

Of course <>""
Thanks Frank