| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Enter dates and return availability
Thankyou! That's just the pointer I needed - have been working with it over
the weekend and the sumproduct is good, thanks! Go well. "vezerid" wrote: Assuming dates in A2:A10, quantities in B2:B10. Further assuming StartDate in G1, EndDate in G2. =SUMPRODUCT(B2:B1, --(A2:A10=G1), --(A2:A10<=G2)) HTH Kostis Vezerides |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula to look up and return smallest date from a range of dates | Excel Worksheet Functions | |||
| 2 digit year in dates return 19xx not 20xx | Excel Discussion (Misc queries) | |||
| return array result in cell based on comparing dates | Excel Worksheet Functions | |||
| Return the latest date from a list of dates | Excel Worksheet Functions | |||
| Seach Column and return multiple dates to another worksheet? | Excel Worksheet Functions | |||
Hybrid Mode
