=N!F15
=S!F15
=E!F15
=W!F15
then do the sum

"PA" wrote:

I have a workbook with 5 worksheets, N, S, E, W and Summary.
On the N, S, E, W worksheets in cell F15 is a sum calculation, =sum(B15:E15).
I want to link each of the 4 sums in F15 to the summary worksheet and then
get an overall sum.
If I copy F15 to the clipboard from the N worksheet, go to the Summary
worksheet, select a cell and paste a link from Paste Special, and then click
the next cell down into which I want to link from the S worksheet, everything
is fine, I get =N!$F$15.
However, if I press Enter, I get an error =SUM(#REF!) and Excel does not
move to the next cell below.
Could someone please explain why I am not able to use the Enter key in this
type of operation.

Many thanks.