Sheet name in a formula

[Rashad]

Hi,

my question is that, when I am putting a formula (for example sum) and the source of information is a different sheet, in formula it shows the name of the sheet that I took the info from. However, when to the same formula I am adding an other value(cell) in a the same sheet that the formula is, it show the name of the sheet as well.

For example, I have 2 worksheets in a file (File1 and File2). I have number in a cell (A1) of File1 and in a cell (B1) of File2. I am putting a formula in File2 wanting to add these 2 numbers. it goes as =File1!A1+File2!B1. Why does it give me the name of File2 if instead of just B1, and how to I remove it.

I am using Excel 2010
windows 7

Thank you.

 

[mashhood]

2 ways to solve your problem.

First arrange your book 1 and book 2 together. . i.e half of your screen should have book 1 and the other half should have book2. . now when you apply the sum formula in book 1 it will not give the book or sheet reference.

2nd option is to go to the formula tab and click insert function. then select sum. using this way will also solve your problem.

TY

 

[Rashad]

Thank you, however example that I showed is not the problem that I have. My data is much bigger and is not the one that I created. I am asking if there is some sort of function that removes all of these..

 

[vlady]

When you click a tab it fetches its name, so usually we input first reference within that sheet then go to the other sheet
say in File 2
put equal sign then click B1 then + -> go to the next tab File1 you'll notice that once you click the tab the name appears in the formula.
=B1 + File1!A1

We'll it doesn't matter since it doesn't affect the formula(computation) really