Thread: Sumproduct between and
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Arlene Arlene is offline
external usenet poster
  
Posts: 38
Default Sumproduct between and
Is it possible to sumproduct((a1:a50=D30)*(b1:b50 between(01/06/07)
and(30/06/07))*c1:c50) I am trying to get a sum of a column based on dates
as well as other criteria. Thanks


Reply With QuoteReply With Quote