Hey guys,

I have a function in an autoupdating spreadsheet that using averageifs() to average between dates. Right now it is skipping zeros or blanks. I need it to averageit all. 

=IFERROR(AVERAGEIFS($Q$8:$Q$269,$A$8:$A$269,">="&$W8,$A$8:$A$269,"<="&$X8),"")
For example 7 days in a week the number is 0 for 6 days on 7 on last day. Now the averageif shows 7 as the average instead of 1 like it should be.


Any help as to watch the alternative is on this. I have tried to change all zeros to blanks or vice versa to get it to calculate correctly but to no avail.

Thanks for any help on this.