Error referencing cell in another sheet

Hello

In Excel 2013 (I think) I am in cell B4 on Sheet 2 and want to reference the value of cell N15 on Sheet 1 which I have re-titled 'Data Input & Stats". My formula for Sheet 2 cell B4 is: ='Data Input & Stats'!N15 but I get a #REF! error.

What am I doing wrong?

Thanks.

Originally Posted by bebo021999

Stay in B4, press F2, click to cell N15 of sheet "data Input & Stats" to see what's displaying in formula bar

=AVERAGE(Input1) is the formula in N15. "Input1" is a range name for a range of input values.

Originally Posted by bebo021999

Whatever the formula in N15 is, but linking to cell N15 to get it's value.

What do you mean by this?

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Attached is the worksheet containing the sheet 2 reference to N15 in sheet 1 (Data Input & Stats). Thanks in advance.

The sheet isn't named
Data Input & Stats

It's Actually named
1) Data Input & Stats

Now I apologize for wasting your time! A good example of why you should never associate with us non-quantitative, non-detail types!!!!

No worries, glad it's sorted.