Excel Guru Please

[springbokkie]

I'm not that good with excel, can anybody help out.

Say i have a value in colum A and B and together I have a formula working out colum C.

So
A = 3
B = 5
C = Sum A1+B1

How can I copy the colum with the formula in it without getting that #REF! error?

 

[Perdition]

Copy it to where?

 

[springbokkie]

Sheet 2

 

[eitai2001]

I'm not that good with excel, can anybody help out.

Say i have a value in colum A and B and together I have a formula working out colum C.

So
A = 3
B = 5
C = Sum A1+B1

How can I copy the colum with the formula in it without getting that #REF! error?

Copy it as you normally would, then when you paste it, instead of the usual routine, right click the cell you want to paste into, and click paste special ... then select values only, and click paste.

 

[springbokkie]

Copy it as you normally would, then when you paste it, instead of the usual routine, right click the cell you want to paste into, and click paste special ... then select values only, and click paste.

Lovely, thank you.

 

[Perdition]

So you just want to copy the values from the formula column into sheet 2?

If so when you paste select Paste Special and select Values

Edit: ahhh beaten!

 

[quovadis]

Or if you wanted to reference the actual values assuming:

A1 is 6 and B1 is 4 and C1 is =SUM(A1:B1) on Sheet1

If you wanted to reference the value of C1 on Sheet2 from Sheet1 then use:
=Sheet1!$C$1

If you wanted to sum A1 and B1 on Sheet2 from Sheet1 then use:
=SUM(Sheet1!$A$1:Sheet1!$B$1)

 

[PearlJam]

Or if you wanted to reference the actual values assuming:

A1 is 6 and B1 is 4 and C1 is =SUM(A1:B1) on Sheet1

If you wanted to reference the value of C1 on Sheet2 from Sheet1 then use:
=Sheet1!$C$1

If you wanted to sum A1 and B1 on Sheet2 from Sheet1 then use:
=SUM(Sheet1!$A$1:Sheet1!$B$1)

and you can do this with different excel files aswell. For instance to do a total of say sales stats or whatever