| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I just don't get it please help relative reference question
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to use address from relative reference across worksheets? | Excel Worksheet Functions | |||
| Trying to use the INDIRECT funtion with a relative Row reference | Excel Discussion (Misc queries) | |||
| Cond. Format & Absolute Cell Reference Question | Excel Discussion (Misc queries) | |||
| How do I change a cell from absolute reference to relative referen | Excel Discussion (Misc queries) | |||
| cell reference question | Excel Discussion (Misc queries) | |||
Threaded Mode
