Finding a Min Value if value in one column less than 0 and second column is not blank

[Evolved]

I'm trying to find the minimum of a range of values in one column but only if the range is less than 0 and the range of values in the same cell but different column has text in it.

I've used this to find the minimum value without the check on the second column and it's working:
{=MIN(IF(D3:D93<0,D3:D93))}

I've tried this logic for checking the second column but it's not working correctly:
{=MIN(IF(AND(D3:D568<0, ISTEXT(C3:C568)=TRUE),D3:D568))}

Any help would be much appreciated!

[Pete_UK]

You can't use AND in array formulae. Try it this way:

{=MIN(IF((D3:D568<0)*(ISTEXT(C3:C568)),D3:D568))}

or slightly simpler:

{=MIN(IF((D3:D568<0)*(C3:C568<>""),D3:D568))}

Hope this helps.

Pete

P.S. Next time use a thread title that describes your problem - see the Forum Rules at the top of the screen.

[Evolved]

Thanks for the quick reply!