Thread: Enter dates and return availability
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
vezerid
 
Posts: n/a
Default Enter dates and return availability
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 With QuoteReply With Quote