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