View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kathryn McC Kathryn McC is offline
external usenet poster
 
Posts: 1
Default Copying DSUM formulas with absolute references

=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 :-)