You are a star Poe. Your suggestion worked like a dream. Thank you so much
and have a great day
--
Gwynneth


"Peo Sjoblom" wrote:

Well that formula is not needed and it doesn't make any sense. You seem to
want 2 criteria, no blank dates since they would be dates over 100 years ago
and a criteria in another range,

=MIN(IF(Range1="x",IF(Date_Range<"",Date_Range)))

will return the earliest date where Range1 equals x, adapt to fit your
requirements and this time enter the formula with ctrl + shift & enter and
finally make sure the cell with this formula is formatted as date or you
will get the serial number


--


Regards,


Peo Sjoblom



"Gwynneth" wrote in message
...
Hi Bernard and thank you for responding. I found a formula yesterday
which
enabled me to find the latest/max date within a range and subject to a
criteria. This formula was: =sumproduct(MAX(--(A:A=A1)*B:B)). So I
thought
I could use this to find the first date/min. However, because there are
blanks agains some criteria these are picked up as the minimum values.

I am therefore hoping there is something I can do the the sumproduct
formula
above that will skip the blanks and give the the first date against a
specifed criteria with multiple dates.

If this is not enough info. I will send you an example spreadsheet if that
pos.

Thanks again
--
Gwynneth


"Bernard Liengme" wrote:

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