| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 :-) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying formulas with relative references | Excel Discussion (Misc queries) | |||
| Fill Data with formulas with Absolute References | Excel Discussion (Misc queries) | |||
| Copying formulas, relative and absolute cell references | Excel Discussion (Misc queries) | |||
| Copying formulas with mixed references | Excel Worksheet Functions | |||
| copying formulas with different references | Excel Discussion (Misc queries) | |||
Linear Mode
