Formula???

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

C J - 19 Oct 2006 21:43 GMT

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

Reply to this Message

Gord Dibben - 19 Oct 2006 21:51 GMT

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

>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

Reply to this Message

C J - 19 Oct 2006 22:02 GMT

Thanks so much for such a speedy answer.
CJ

> Assuming your have data in A1 of sheet1 and data in A1 of sheet2
>
[quoted text clipped - 12 lines]
>>Thanks,
>>CJ

Reply to this Message