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:

='Sheet2'!D52
--
Kevin Backmann


"jmh" wrote:

how do i take a sum that has been calculated on sheet 2 and automatically
have it trannsferred to a designated cell on sheet 1?