Formula???

C

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
 
G

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
 
Top