D
Dan
I want to take inputs from two pages and summarize them on a 3rd page within
the same notebook. How can I do this?
the same notebook. How can I do this?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
K
Khoshravan
If by page, you mean worksheets, in destination sheet (in your case 3rd page)
enter "=" and then click the sheet tab at the buttom and click the desired
cell. when you finished referencing your cells in this manner, click enter.
Now if you look to the cell you have entered the formula, you can see the
sheet name before cell references separated by a "!", which means it has
brought the parameteres from those sheet.
In this manner you can reference any cell from the same workbook and even
from other workbooks (Excel files)
HTH
enter "=" and then click the sheet tab at the buttom and click the desired
cell. when you finished referencing your cells in this manner, click enter.
Now if you look to the cell you have entered the formula, you can see the
sheet name before cell references separated by a "!", which means it has
brought the parameteres from those sheet.
In this manner you can reference any cell from the same workbook and even
from other workbooks (Excel files)
HTH
D
Dan
That pretty much makes sense, but can you post an example of what the formula
would look like? I can't visualize it. Thanks in advance!
would look like? I can't visualize it. Thanks in advance!
G
Gord Dibben
Would look something like............
=Sheet1!A1 * Sheet2!A1 if you were multiplying the two cells from Sheet1 and
Sheet2
Or =SUM(Sheet1:Sheet2!A1) if summing the two cells
Or maybe =SUM(Sheet1!A1:Sheet2!A1) if you were to let Excel compose the
formula.
Many variations depending upon what you want to do with the cells.
Gord Dibben MS Excel MVP
=Sheet1!A1 * Sheet2!A1 if you were multiplying the two cells from Sheet1 and
Sheet2
Or =SUM(Sheet1:Sheet2!A1) if summing the two cells
Or maybe =SUM(Sheet1!A1:Sheet2!A1) if you were to let Excel compose the
formula.
Many variations depending upon what you want to do with the cells.
Gord Dibben MS Excel MVP
K
Khoshravan
Gord Dibben has given good examples before me. Just follow the steps and you
will the results by yourself. Thanks Gord
will the results by yourself. Thanks Gord