Home |
Search |
Today's Posts |
#1
|
|||
|
|||
calculations from data in other worksheets
I used to perform these calculations all the time in a previous version of
excel, but now I either can't remember how to do it, or the functionality has changed. I have excel 2000. What I am trying to do is this: Use data from the current worksheet and data from another worksheet in the same workbook in a simple formula. I used to select the cell I wish the formula to be in, then using the control key, select the various cells from this and other worksheets that are needed to complete the SUM formula and hit enter. Voila! the answer is there! I cannot now seem to be able to enter data from multiple sheets into one cell as a formula. It will allow ONE reference, but not two. Can anyone help me? I'm trying to do this by selecting cells----I don't want to have to TYPE cell references as the spreadsheet is too large and complex....it would take forever! Can anyone help me? Thank you, Tolleen |
#2
|
|||
|
|||
Hi!
That works as long as you're CTRL clicking cells all on the same sheet. When you need to goto a different sheet you'll have to let go of the CTRL key then manually enter a comma in the formula then goto the next sheet and you can then continue CTRL clicking cells. Biff -----Original Message----- I used to perform these calculations all the time in a previous version of excel, but now I either can't remember how to do it, or the functionality has changed. I have excel 2000. What I am trying to do is this: Use data from the current worksheet and data from another worksheet in the same workbook in a simple formula. I used to select the cell I wish the formula to be in, then using the control key, select the various cells from this and other worksheets that are needed to complete the SUM formula and hit enter. Voila! the answer is there! I cannot now seem to be able to enter data from multiple sheets into one cell as a formula. It will allow ONE reference, but not two. Can anyone help me? I'm trying to do this by selecting cells----I don't want to have to TYPE cell references as the spreadsheet is too large and complex....it would take forever! Can anyone help me? Thank you, Tolleen . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate data on 2 different worksheets | Excel Discussion (Misc queries) | |||
data entry on multiple worksheets | Excel Discussion (Misc queries) | |||
Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel | |||
Assigning Cells in worksheets to other data in other worksheets. | Excel Discussion (Misc queries) | |||
cells lose relativity to other WorkSheets after data sort? | Excel Worksheet Functions |