| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
i've tried every thing relative reference problem.
SUMPRODUCT(--('C:\Documents and Settings\Tom\Desktop\TUCSON
07\[1DLSUNDAY.xlsm]601'!$I2:$U20=$A3)) - SUMPRODUCT(--('C:\Documents and Settings\Tom\Desktop\TUCSON 07\[1DLSUNDAY.xlsm]601'!$W2:$AA20=A3)) I don't understand why the A3 won't change to A4 when I drag this formula down I need to populate 100 cells in a column and don't want to have to change it manually. As you can see I have tried both the $A3 and just A3 but nothing changes. Please help me understand. Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
i've tried every thing relative reference problem.
Are you dragging down, or are you copying in the formula bar, and copying
down? The first will work, the second will keep the original address. -- Hth Kassie Kasselman "Tomkat743" wrote: SUMPRODUCT(--('C:\Documents and Settings\Tom\Desktop\TUCSON 07\[1DLSUNDAY.xlsm]601'!$I2:$U20=$A3)) - SUMPRODUCT(--('C:\Documents and Settings\Tom\Desktop\TUCSON 07\[1DLSUNDAY.xlsm]601'!$W2:$AA20=A3)) I don't understand why the A3 won't change to A4 when I drag this formula down I need to populate 100 cells in a column and don't want to have to change it manually. As you can see I have tried both the $A3 and just A3 but nothing changes. Please help me understand. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA problem for forumla with relative reference | Excel Worksheet Functions | |||
| Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
| problem with relative reference | Excel Programming | |||
| Relative Reference | Excel Discussion (Misc queries) | |||
| relative reference | New Users to Excel | |||
Linear Mode
