Junior Member

Posts: 4

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?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Template Wizard/Excel as database	TG	Excel Worksheet Functions	0	April 20th 06 09:03 PM
Trouble with formula on Student 2006 learning essentials template	Student in BC	Excel Worksheet Functions	1	December 27th 05 07:05 AM
I need a Corrective Action Database template	mdalzell	Excel Discussion (Misc queries)	1	November 1st 05 02:47 PM
Database functions should use criteria in formula, as 1-2-3 does	123user	Excel Worksheet Functions	8	September 29th 05 08:57 PM
Formula Template	Carole O	Excel Worksheet Functions	0	March 24th 05 06:59 PM

All times are GMT +1. The time now is 02:04 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us