Copying DSUM formulas with absolute references

Kathryn McC

Guest

Posts: n/a

19th Jun 2008

=DSUM('Bill Log 2007-2008'!$A:$O,"Amount",'Bill Crit-FHC'!$AB$15:$AD$16)
I have inserted two colums in between the next working column so the pasted
formula should read: =DSUM('Bill Log 2007-2008'!$A:$O,"Amount",'Bill
Crit-FHC'!$AE$15:$AG$16)
and so on...does this make sense? I've tried over and over again choosing
different options, formatting only, formulas and formatting. I am about to
go batty. Thanks :-)

« A formula to ponder on - I burnt myself out ! | Fund return v income »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Copying formulas, relative and absolute cell references	=?Utf-8?B?R2FybmV0?=	Microsoft Excel Misc	3	22nd Feb 2007 08:51 AM
Shortcut to convert all formulas to absolute references?	Kevlar	Microsoft Excel Misc	1	15th Oct 2004 12:50 AM
copying absolute references	Dave W	Microsoft Excel Worksheet Functions	2	12th Jul 2004 05:29 PM
Changing all Formulas to Absolute References	Arska	Microsoft Excel Misc	2	19th Aug 2003 07:11 PM
Changing all Formulas to Absolute References	Arska	Microsoft Excel Discussion	2	19th Aug 2003 07:11 PM