| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUMPRODUCT: Help to use this to find min date in range for criter
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying rows from 2 sheets to a new worksheet based on date criter | Excel Discussion (Misc queries) | |||
| SUMPRODUCT between date range | New Users to Excel | |||
| Sumproduct with date range | Excel Worksheet Functions | |||
| Sumproduct Will Not Find Date | Excel Worksheet Functions | |||
| Excel: How to return count for each cell within date range criter. | Excel Worksheet Functions | |||
Threaded Mode
