Hey all,

Been trying to get this for hours!

I have this forumla

{=SUMPRODUCT(MIN(($D$2:$D$3653)*($C$2:$C$3653=$I25)))}
I need it to return the minimum value in the D range, where the C range is equal to I25. This is does fine, however there are zero/blank cells in the D range.

I need it to return the minimum value in the D range that is not zero/blank.

Any ideas?

thanks very much