Hi,

I have a sheet providing the summary of a contract (TOTALSBYPO). Another
sheet provides the details, including amendments made to a contract
(CONTRACTDATAENTRY).

I want to get the earliest date of a contract and the latest date of a
contract into my summary based on the PO number being the same.

Exemple. On sheet TOTALSBYPO I want to indicate the "Start Date" of PO
9841 in cell C5.

here's what I have:

=MIN((CONTRACTDATAENTRY!D:D)*(CONTRACTDATAENTRY!A: A=$C5))

I get #num error based on this.

Any help is greatly appreciated.