How do you make calculations between different tabs?

A

Andrew1029

Hi,

I want to make a spreadsheet that summaries information from previous
tab/worksheets within a single excel file.

For instance can you do A1 from sheet 1 multiplied by A1 from sheet 2, with
the answer appearing in A1 of sheet three?

Are these types of calculations and connections possible in excel?
 
D

David Billigmeier

Yes, use this notation:

In cell A1 in sheet 3:

='sheet 1'!A1 * 'sheet2'!A1
 
B

Bernard Liengme

In A1 of Sheet3 enter =Sheet!A1*Sheet2!A1
It is often easier to make these formulas by pointing: in A1 of Sheet3 type
=, click on Sheet1's tab and click on A1, in the formula bar type *, click
on Sheet2's tab and then on A1; complete formula with either Enter key of
the green check mark next to formula part.
Note: if sheet name have spaces, you need single quotes, as in 'January
data'!a1
best wishes
 
Top