Bothe of those should change when you drag them down as both have a relative
row number.

--
HTH

Bob Phillips

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Tomkat743" wrote in message
...
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