Thread: SUMPRODUCT with Date Range
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
LouD LouD is offline
external usenet poster
  
Posts: 3
Default SUMPRODUCT with Date Range
Bob,

This formula works perfect:

=SUMPRODUCT((B2:B347=D349)*(B2:B347<=D350)*(ISNUM BER(SEARCH("39BD382",C2:R347))))

Thanks for all your help.
Reply With QuoteReply With Quote