Formula???

[C J]

What is the formula that will add the content of a cell on one worksheet
(sheet 1) to the contents of another worksheet (sheet 2)?
Thanks,
CJ

 

[Gord Dibben]

Assuming your have data in A1 of sheet1 and data in A1 of sheet2

In B1 of sheet2 enter =A1 & sheet1!A1

If you wish a space between enter as =A1 & " " & sheet1!A1

If by "add" you mean "sum"

In B1 enter =SUM(A1,sheet1!A1)


Gord Dibben MS Excel MVP

 

[C J]

Thanks so much for such a speedy answer.
CJ

Assuming your have data in A1 of sheet1 and data in A1 of sheet2

In B1 of sheet2 enter =A1 & sheet1!A1

If you wish a space between enter as =A1 & " " & sheet1!A1

If by "add" you mean "sum"

In B1 enter =SUM(A1,sheet1!A1)


Gord Dibben MS Excel MVP