Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using VBA select sll sheets based on Criteria on each sheet. | Excel Discussion (Misc queries) | |||
Add a row based on other criteria | Excel Worksheet Functions | |||
Selecting a criteria range over two sheets? | Excel Discussion (Misc queries) | |||
Need help looking up value based on criteria | Excel Worksheet Functions | |||
populating sheets based on data from parent sheets | Excel Discussion (Misc queries) |