Thread: Average data with date and if constraints
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jrheinschm
 
Posts: n/a
Default Average data with date and if constraints
=SUMPRODUCT(--(A2:A213=C224),--(A2:A213<=C225),--(W2:W213=1),H2:H213)/SUMPRODUCT(--(A2:A213=C224),--(A2:A213<=C225),--(W2:W215=1),H2:H213)
This is the suggestion one of you gave me, however it doesn't seem to work.
col A are dates

I've been working on this for hours and can't get it??
Please help
Reply With QuoteReply With Quote