Greetings-

I am trying to create a template from an existing workbook. I have been successful for the most part, by pasting new data over a copy of the model workbook using the paste special-skip blanks feature. However my DAVERAGE formulas are returning a DIV/0 error. The formula appears syntactically correct. Specifically, I have copied the formula =DAVERAGE($D$4:$BQ31,4,$A$1:$B$2) and when pasted (in one example) it appears as =DAVERAGE($D$4:$BQ27,4,$A$1:$B$2). What step am I missing?