TomKat,
You've multiposted what's essentially this same question in the same newsgroup. Best not to
multipost, as folks can wind up working on a question for you that may have been answered in
the other post. Same for multiposting in different newsgroups. Just thought it worth
mentioning
1) Does the formula in the first cell yield the correct result? If not, fix that first.
2) Or do you see the formula in the cell instead of the result it should yield?
3) If you put another formula, perhaps a simple one like =A3 + 1, in that same cell and
drag the Fill Handle down to copy it, does it increment the cell references as it should?
Does the formula work properly with something in A3?
Maybe the answers to these might shed some light, and someone might figure it out.
--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
Tomkat743 said:
Tomkat743 said:
=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