Solved Can I create a formula between sheet 1 & sheet 2?

August 27, 2013 at 15:17:29
Specs: Windows 7
I'm trying to create a formula on sheet 2 to add the numbers on sheet 1 to numbers on sheet 2. Is this possible?

See More: Can I create a formula between sheet 1 & sheet 2?

Report •

#1
August 27, 2013 at 18:12:01
✔ Best Answer
If your number is in cell B1 on Sheet 1
and your second number in in Cell A1 on Sheet 2
in cell C1 on Sheet 2 then try this:

=A1+Sheet1!B1

Also, Excel questions are best asked in the Office Software Forum.

MIKE

http://www.skeptic.com/


Report •

#2
August 27, 2013 at 18:52:23
Thank you for your guidance. It works. Just need to use my reading glasses because at first I didn't realize it was a ! sign. I thought it was this / sign until I enlarged it.

Appreciate your response. Now I can continue to do what I need to do.

; )


Report •
Related Solutions


Ask Question