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

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