Database Formula in a Template
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? |
All times are GMT +1. The time now is 06:12 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com