There should be an =AVERAGEIF() formula:
Formula: copy to clipboard
=AVERAGEIF(Data_By_Days_Applications!$F$3:$F$15,F67,Data_By_Days_Applications!$G$3:$G$15)

If you are using Excel 2007.