Can I have a formula with inputs from multiple pages?
Gord Dibben has given good examples before me. Just follow the steps and you
will the results by yourself. Thanks Gord
--
Rasoul Khoshravan Azar
Kobe University, Kobe, Japan
"Dan" wrote:
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!
"Khoshravan" wrote:
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
--
Rasoul Khoshravan Azar
Kobe University, Kobe, Japan
"Dan" wrote:
I want to take inputs from two pages and summarize them on a 3rd page within
the same notebook. How can I do this?
|