Thread: Sumproduct & Date multiple criteria
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
TomPl TomPl is offline
external usenet poster
  
Posts: 342
Default Sumproduct & Date multiple criteria
Also,

The named range cannot be an entire column (e.g. "A:A") but must include
rows (e.g. "A1:A65536" or "B1:B12").

Tom

Reply With QuoteReply With Quote