formula in Excel

[Patty]

I would like to know how to put in a formula into a worksheet that contains
info from another worksheet. Example: I am keeping track of vacation hours
for employees and on the last worksheet I have the total vacation hours
available in one spreadsheet for all employees. Is this something that can
be done and how?

 

[Gary''s Student]

Use a linking formula. For example:
=Sheet3!G28
will get a value from Sheet3 cell G28

 

[David Biddulph]

Click in the destination cell on your destination sheet, and type the =
sign.
Go to your source sheet and click in the source cell.
The formula in the destination cell will now look something like ='Sheet
2'!B2
If you want more in the formula, add further operators and continue, so you
could have ='Sheet 2'!B2+Sheet3!C3 and so on.
Accept the formula when you are finished.

 

[Patty]

All I get is a #REF! error.

 

[Gary''s Student]

Make sure Sheet3 exists!

 

[David Biddulph]

If you get a #REF! error you presumably don't have a sheet called Sheet3.
If your sheet name includes spaces, you need to surround the sheet name with
single quotes, such as:
='First sheet'!G28