Workbook formulas

  • Thread starter Thread starter fs1
  • Start date Start date
F

fs1

I know this is probably a pretty simple question, but I need to ask it
because I can't figure out how to do it myself.

I have a workbook that has three worksheets in it. The third worksheet
is supposed to take totals from worksheets 1 and 2 and combine them.
What my problem is is that I don't know how to reference the cells from
worksheets 1 and 2when doing a formula on the third worksheet to combine
cell totals from worksheets 1 and 2. I don't know what those cells
would be named? Does this make sense? Thanks for any help.
 
Assuming that your two sheets are named Sheet1 and Sheet2, on Sheet3 use
this formula:

=Sheet1!A1+Sheet2!A1

Note the "!" is used to designate the name of a sheet.

HTH

Bruce
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Is a combination of INDIRECT with INDIRECT.EXT, a component ofmorefunc.xll by Laurent Longre, valid? 1
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel VBA 1
Copy cells in Excel 1
how do I use a cell from one worksheet in the equation of another 3
Excel Count If Formula Question 1
Worksheet Names using Macros 5
refresh? 2

Back
Top