Sheet name in a formula

Rashad

New Member
Joined
Jan 8, 2014
Messages
7
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.
 

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

mashhood

New Member
Joined
Dec 24, 2013
Messages
47
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

New Member
Joined
Jan 8, 2014
Messages
7
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

Active Member
Joined
Jan 26, 2012
Messages
413
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
 

Watch MrExcel Video

Forum statistics

Threads
1,129,685
Messages
5,637,809
Members
416,983
Latest member
LessThanAverageUser

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top