How do you make calculations between different tabs?
 

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?

Yes, use this notation:

In cell A1 in sheet 3:

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

--
Regards,

Dave


"Andrew1029" wrote:

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?

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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Andrew1029" wrote in message
...
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?