Can I have a formula with inputs from multiple pages?

[Guest]

I want to take inputs from two pages and summarize them on a 3rd page within
the same notebook. How can I do this?

 

[Guest]

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

 

[Guest]

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!

 

[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

 

[Guest]

Gord Dibben has given good examples before me. Just follow the steps and you
will the results by yourself. Thanks Gord