Thread: How do I obtain the Average Values between 2 dates?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Domenic
 
Posts: n/a
Default How do I obtain the Average Values between 2 dates?
Try...

=AVERAGE(IF(Daily!$A$4:$A$604Weekly!A4,IF(Daily!$ A$4:$A$604
<=Weekly!A5,IF(Daily!$B$4:$B$604<"",Daily!$B$4:$B $604))))

....confirmed with CONTROL+SHIFT+ENTER.

In article ,
gimiv wrote:

That worked, excellent. Thanks Domenic. One last thing, how do I get it
to ignore blank cells (holidays)
Reply With QuoteReply With Quote