Thread: Adding values that fall between 2 dates
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dwells Dwells is offline
external usenet poster
  
Posts: 1
Default Adding values that fall between 2 dates
i'm using this to add values that are between 2 dates
=SUMPRODUCT(--(G8:G26=DATEVALUE("1/1/2010")),--(G8:G26<=DATEVALUE("1/30/2010")),F8:F26)

but i need the dates 1/1/2010 and 1/30/2010 to be user input. so that those
values are reading from another cell. is this possible
Reply With QuoteReply With Quote