Conquer Club

How do I reference a field on one page of a workbook from another page?

Example: Keeping each week of a complex tournament on it's own workbook page, can I forward the score totals from each week to the final week's page, so as to sum those pages on the final page AUTOMATICALLY? I already sum each player's score on the weekly sheets.

Supposing you have a sheet called Sheet2, you can make a cell reference by using:

Code: Select all

=Sheet2!A1

If you want the sum of a range of cells on Sheet2, you can use this sort of notation (note, you only have to precede the entire range with the sheet name, not each end of the range):

Code: Select all

=SUM(Sheet2!A1:A8)

If your sheet name has more than one word (ie - has spaces) use single quotation marks:

Code: Select all

=SUM('Sheet Two'!A1:A8)

Many, MANY Thanks. Exactly what I was looking for.