I have got three sheets arranged like:
Sheet1
A1=Vicki B1=1 C1=1
A2=Eric B2=4 C2=2
Sheet2
A1=Vicki B1=2 C1=2
A2=Eric B2=10 C2=1
The third sheet references values in sheet 1 and 2 and calculates a total
A1=Vicki B1='Sheet1!B$1'+'Sheet2!B$1' (results in 2+1 =3)
A2=Eric B2='Sheet1!B$2'+'Sheet2!B$2'
(results in 4+10=14)
If I was to drag B1 to B2 to get the result of B2, the formula 'Sheet1!B$1' gets copied and not 'Sheet1!B$2'. I have a referencing problem here. But it works the way I want it when dragging B1 to C1. The rows and columns get updated necessarily. I was wondering if anyone knew of a way so that if was to drag B1 to C1 the formula would calculate Sheet1C1+Sheet2C1 in C1.
and when I drag B1 to B2 at the same time, the formula in B2 would calculate Sheet1B2+Sheet2B2
This message was edited by excelled on 2002-08-26 15:09
This message was edited by Excelled on 2002-08-26 15:10
This message was edited by Excelled on 2002-08-26 15:11
This message was edited by Excelled on 2002-08-26 15:13
This message was edited by excelled on 2002-08-26 15:49
Sheet1
A1=Vicki B1=1 C1=1
A2=Eric B2=4 C2=2
Sheet2
A1=Vicki B1=2 C1=2
A2=Eric B2=10 C2=1
The third sheet references values in sheet 1 and 2 and calculates a total
A1=Vicki B1='Sheet1!B$1'+'Sheet2!B$1' (results in 2+1 =3)
A2=Eric B2='Sheet1!B$2'+'Sheet2!B$2'
(results in 4+10=14)
If I was to drag B1 to B2 to get the result of B2, the formula 'Sheet1!B$1' gets copied and not 'Sheet1!B$2'. I have a referencing problem here. But it works the way I want it when dragging B1 to C1. The rows and columns get updated necessarily. I was wondering if anyone knew of a way so that if was to drag B1 to C1 the formula would calculate Sheet1C1+Sheet2C1 in C1.
and when I drag B1 to B2 at the same time, the formula in B2 would calculate Sheet1B2+Sheet2B2
This message was edited by excelled on 2002-08-26 15:09
This message was edited by Excelled on 2002-08-26 15:10
This message was edited by Excelled on 2002-08-26 15:11
This message was edited by Excelled on 2002-08-26 15:13
This message was edited by excelled on 2002-08-26 15:49