Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I make some columns all caps and others proper? | Excel Discussion (Misc queries) | |||
Calculations crossing multiple sheets | Excel Discussion (Misc queries) | |||
Can you make a cell with a diagonal, so that you can edit the upper and lower part of the cell? | New Users to Excel | |||
make hidden window or workbook visible without specify the name | Excel Worksheet Functions | |||
make a cell empty based on condition | Charts and Charting in Excel |