Jump to content

calculations across worksheets


Recommended Posts

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

Link to comment

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...