Addition to a number retrieved from different sheet

[Rizana]

I'm working with 2 Excel sheets, PLY TABLE and LIBRARY TABLE.
PLY TABLE will allow the user to insert the corresponding data and the LIBRARY TABLE will display the summary of the data entered in PLY TABLE.

The problem is that, how could I possibly do a mathematical operation to the value in PLY TABLE to be displayed in the LIBRARY TABLE?

Example: I want to add the value in PLY TABLE, cell H29 with 6? I tried to used this code, but it doesn't work out.

=('PCR-Master'!H29)+6

I believed that this is just a simple one, but I really don't know how.

Any ideas?
Any help is appreciated.

 

[stanleydgromjr]

Try taking the space out of the sheet name.

Use this:
=(PLYTABLE!H29)+6


Have a great day,
Stan

 

[pgc01]

Hi Rizana

It should be

='PLY TABLE'!H29+6

Where did the 'PCR-Master' come from? Do you have other worksheets in your workbook?

Hope this helps
PGC

 

[Derek]

Hi there

Your formula refers to a sheet which is not called PLY TABLE. All you need to do is type the = sign, then select H29 in the other sheet, then "+6" from your keyboard (without the quotes), and press ENTER.

regards
Derek

 

[Rizana]

Yeah..it shoud be PLY TABLE, not PCR-Master!
Sorry, typo.