G
Guest
Tomkat743 said:
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bob Phillips
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)
row number.
--
HTH
Bob Phillips
(there's no email, no snail mail, but somewhere should be gmail in my addy)
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
G
Guest
I BELIEVE IT SHOULD BUT IT DOESN'T!!!!
I can't figure it out could it be a setting in the new 2007 office? I've
changed everything I can think of but thank you for the feedback.
I can't figure it out could it be a setting in the new 2007 office? I've
changed everything I can think of but thank you for the feedback.
Bob Phillips said: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 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
B
Bob Phillips
No, I am telling you it should and it does, even in 2007. I had a look at
the options in 2007 and I couldn't see anything obvious that could cause
such happenings.
--
HTH
Bob Phillips
(there's no email, no snail mail, but somewhere should be gmail in my addy)
the options in 2007 and I couldn't see anything obvious that could cause
such happenings.
--
HTH
Bob Phillips
(there's no email, no snail mail, but somewhere should be gmail in my addy)
Tomkat743 said:I BELIEVE IT SHOULD BUT IT DOESN'T!!!!
I can't figure it out could it be a setting in the new 2007 office? I've
changed everything I can think of but thank you for the feedback.
Bob Phillips said: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)
just A3Tomkat743 said: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
butnothing changes. Please help me understand. Thanks
G
Guest
How do you drag down? Have you tried copy and paste? You may also want to try
this: select your 100 cells then with the top cell active click on F2 then
hold down the CTRL key and hit ENTER.
HTH
Jean-Guy
this: select your 100 cells then with the top cell active click on F2 then
hold down the CTRL key and hit ENTER.
HTH
Jean-Guy
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
D
Dave Peterson
You have a followup at your first post.
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
E
Earl Kiosterud
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
-----------------------------------------------------------------------
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