How to get data between tabs in Google Spreadsheets

Question

is it possible to get a value from a tab cell and work with it in another tab?

Tab 1 (T1)
row  working hours (A)    who (B)
1    3                    Mike

-------------------------------

Tab 2 (T2)
row  price (A)
1    25€

-------------------------------

Tab 3 (T3)
total (A)
75€ =(T1.A*T2.A)

score 1 · Answer 1 · answered Mar 28 '11 at 11:03

Found it on Google Docs Support Forum

Tab 1 (T1)
row  working hours (A)    who (B)
1    3                    Mike

-------------------------------

Tab 2 (T2)
row  price (A)
1    25€

-------------------------------

Tab 3 (T3)
total (A)
75€ =('Tab 1'!A1*'Tab 2'!A1)

How to get data between tabs in Google Spreadsheets

1 Answers1