Workbook formulas

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.
 
S

swatsp0p

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
 
Top