The formula will not work when the N/A is in the column.
I thought this should work but something is in error
Thank you very much for your help.
IF(ISERROR(AVERAGEIFS($F$8:$F$372,$A$8:$A$372,"<>#n/a")<8-1-2015",$A$8:$A$372,"<>#n/a")>6-30-2015")),"0",AVERAGEIFS($F$8:$F$372,$A$8:$A$372,"<>#n/a")<8-1-2015",$A$8:$A$372,"<>#n/a")>6-30-2015"))
I thought this should work but something is in error
Thank you very much for your help.
IF(ISERROR(AVERAGEIFS($F$8:$F$372,$A$8:$A$372,"<>#n/a")<8-1-2015",$A$8:$A$372,"<>#n/a")>6-30-2015")),"0",AVERAGEIFS($F$8:$F$372,$A$8:$A$372,"<>#n/a")<8-1-2015",$A$8:$A$372,"<>#n/a")>6-30-2015"))