Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I create a formula using cells from multiple worksheets?
I would like to use a subtotal cell from worksheet 1 and have the total cell
in worksheet 2 look at that cell and add it in to worksheet 2 cell total and so on up to around twelve worksheets in the same workbook. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I create a formula using cells from multiple worksheets?
Genevie
Not sure of what you want, but if you want to create a formula that adds up values located in cells in different sheets, do this: Select the cell in which you want the formula. Do NOT hit Enter until the end. Type "=" without the quotes. Select the first cell you want to add. It doesn't matter in what sheet that cell is located. Go to that sheet and click on that cell. Type "+" without the quotes. Select the next cell. Type "+" without the quotes. Keep going until you reach and select the last cell. Hit Enter. Done HTH Otto "genevie" wrote in message ... I would like to use a subtotal cell from worksheet 1 and have the total cell in worksheet 2 look at that cell and add it in to worksheet 2 cell total and so on up to around twelve worksheets in the same workbook. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create multiple sheet tabs from multiple cells. | Excel Worksheet Functions | |||
copy a formula into multiple worksheets and change 1 row down each | Excel Discussion (Misc queries) | |||
Match then lookup | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
adding certain cells in multiple worksheets in multiple workbooks | Excel Worksheet Functions |