calculations across worksheets

[hgb 0]

Is it possible to define a formula in one worksheet that references a cell in another worksheet in the same file?

Any suggestions will be appreciated!

[Janis Kent 0]

Yes. You would use the following formula

= 'name of other worksheet' : cell location in other worksheet

basically, after the equals sign (=) you would type in the name of the other worksheet within single quotes, being careful to use upper and/or lower case exactly as the other worksheet is named. then a colon mark and the cell location such as B4 or D2.

------------------

Janis Kent, AIA

author WorksTutorial & WorksManual