Move to the cell in sheet one where you want to place the sum reference and
do the following:
Type an = sign
Press Ctrl + PgUp to move to sheet2
Click the cell with the sum
Press Enter to complete the formula
Or you can type the entire formula by entering the name of the worksheet,
enclosed in single quotes, followed by the cell address that has the sum
formula. See example below:
Move to the cell in sheet one where you want to place the sum reference and
do the following:
Type an = sign
Press Ctrl + PgUp to move to sheet2
Click the cell with the sum
Press Enter to complete the formula
Or you can type the entire formula by entering the name of the worksheet,
enclosed in single quotes, followed by the cell address that has the sum
formula. See example below:
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.
