SUMIF, ignoring blanks and find earliest date ignoring blanks

Hi everyone,

My latest question revolves around summing the total of parts required and showing the earliest requirement date.

I have a table (TABLE A) with 3 columns: Part, Demand, Req. Date (requirement).

In a separate table (TABLE B), I want to show the total demand for each part and the earliest requirement date for that part.

Please see attached workbook.

You will see on Table A, that there are blank dates, real dates, and the generic 00/01/1900 date. the table source information will always be like this and at the moment I cannot alter it.

The first thing I want to do in Table B is show the total demand for the part where the date is [B][U]not[B][U] either blank or "00/01/1900".
Secondly, in column G, I want to show the earliest requirement date for the part, ignoring any blanks and 00/01/1900's.

As you will see from the sheet called "WHAT I HAVE" - it isn't working out!

I have tried putting various if & and statements if the formulas to try to exclude lines where the date is blank, but nothing works - so it is time to turn to the experts (you guys!).


Any help more than gratefully received!


many thanks
Chris

How about
=IFERROR(AGGREGATE(15,6,$C$5:$C$13/(($C$5:$C$13>0)*($A$5:$A$13=E5)),1),"")

Thanks to both your super fast replies!

Ali - both of those work a charm; thank you very much for your help.

Chris