REF error

[otis1978]

I have just updated to Office 16. I am trying to add a cell from worksheet and a cell from another worksheet. I use the formula; =A1(first worksheet) + a1(second worksheet) and enter. I am getting a REF error and a dialog box that look slike it needs to know a file location?

Thanks, Mark

 

[Fluff]

Try
=Sheet1!A1+Sheet2!A1