See if this array formula works for you:

=MIN(IF(PO1=A2,IF(Created<"",Created),""))

NOTE: Array functions are entered with CTRL-SHIFT-ENTER instead of just
Enter. If done properly, the formula will be enclosed in { }.

HTH,
Elkar


"Gwynneth" wrote:

I am trying to find the minimum date in a range, which contains blanks.
subject to a criteria. As the range contains blanks, these are currently
picked up as the min date and display 00-Jan-00.

Is there a way of using sumproduct and excluding/ignoring blank cells?

PO1 is my range for criteria and Created1 is my range on the dates I am
using in the following formula

=Sumproduct(MIN(--(PO1=A2)*Created1))

Gwynneth

--
Gwynneth