# Referencing a Cell in Another Sheet in CALC

I have a calc file with 201 sheets, the 201st is called Totals. I would like to display the contents of a cell from the Totals sheet .... for example, in Sheet 1, I want the contents of cell G1 of the Totals sheet. In Sheet 2, I want the contents of cell G2 in the Totals sheet. The closest I can come up with is >

=Totals.G&"Sheet()"

Haven't been able to figure it out. Thanks!

edit retag close merge delete

Sort by » oldest newest most voted

@m.a.riosv : think twice over stuff with INDIRECT(ADDRESS...

=INDIRECT("Totals.G" & SHEET())

more

I would add that if you want the result to the same position in all the sheets you can select sheets before entering. Steps to Reproduce:

1. Click on the tab of the first sheet
2. Shift + Click on the last sheet tab (before "Totals")
3. Click in the cell where you want the result and then enter the formula given by mariosv
( 2015-02-19 09:47:07 +0200 )edit

Thank you very much - perfect!

more

Delete this answer !

( 2015-02-20 13:53:24 +0200 )edit

Try with a formula like: =INDIRECT(ADDRESS(SHEET();7;1;1;"Totals");1) It takes the row number from SHEET() which gives the sheet number, ADDRESS() gives the address as text and INDIRECT() returns the value for text address.

more

Trying my luck: put ='Totals'.G2 to the cell you want something to appear in. That's how Google converted a spreadsheet from their own format to ODS and it worked just fine when I changed some values.

more

@rautamiekka: did you read and understand the question ??

( 2015-02-19 09:32:21 +0200 )edit

@karolus: I could had misunderstood it.

( 2015-02-20 13:53:45 +0200 )edit

## Stats

Asked: 2015-02-18 23:15:50 +0200

Seen: 4,724 times

Last updated: Feb 19 '15