This finds the minimum value in the A range subject to the corresponding B
value being "a". But if there are two cases you get twice the answer.
=SUMPRODUCT(--(A1:A16=MIN(A1:A16)),--(B1:B16="a"))

Can you please expand on your problem. You want to find the minimum value of
PO1 with the proviso that the date in also in the range Created1? With named
ranges we cannot see the whole picture. For example what is the size of each
range?

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Gwynneth" wrote in message
...
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