Multiple worksheet question

[PennState]

In Excel 2010, I have 3 worksheets set up: Total Revenue (sheet 1), Total Payroll (sheet 2), and Final Projections (sheet 3).

In sheet 2, cell B37, the total payroll expenses which was generated from a simple addition formula of other cells in sheet 2 is present.

I need to reference that cell in a new formula in sheet 3 as part of a formula to determine operating costs in cell B6. Also, I would need the amount in B6 on sheet 3 to change if the amount in B37 in sheet 2 changed.

Each time I've tried to reference B37 from sheet 2 with the formula in B6 from sheet 3 I either end up with 0 displayed in the cell or an error message.

How would I get this to work?

 

[VoG]

In B6, Sheet3

=Sheet2!B37

 

[PennState]

In B6, Sheet3

=Sheet2!B37

I tried that bud and I keep getting an "invalid cell reference error".

Would it make a difference if the sheets were renamed?

 

[VoG]

Yes, you need to use the name shown on the sheet tab. For example

='My Data'!B37

 

[PennState]

Yes, you need to use the name shown on the sheet tab. For example

='My Data'!B37

Ok, so mine would/should look like this: ='Total Payroll'!B37*.40

That right?

 

[PennState]

Yes, you need to use the name shown on the sheet tab. For example

='My Data'!B37

You sir/ma'am are THE MAN!!! Thanks a million!!!