Min/Max based on criteria (2 sheets)
 

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.

Min/Max based on criteria (2 sheets)
 

Hi I also tried

=MIN(IF(CONTRACTDATAENTRY!$A:$A=$C6,CONTRACTDATAEN TRY!$D:$D))

These are all with { } (array) crtl-shift-enter being entered after the
formula

Thanks again

"Jean-Francois Gauthier" wrote:

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.