G Guest Jun 3, 2004 #1 the sum from one cell on sheet1 from another cell on sheet2,how do you do the formula
J jeff Jun 3, 2004 #2 qwerty: To sum the value on Sheet1, cell A10 with the cell value Sheet2, cell B20, enter =Sheet1!A10 + Sheet2!B20 (or you can enter '=' sign and click on A10, then enter the plus sign and click on B20) jeff -----Original Message----- the sum from one cell on sheet1 from another cell on Click to expand... sheet2,how do you do the formula
qwerty: To sum the value on Sheet1, cell A10 with the cell value Sheet2, cell B20, enter =Sheet1!A10 + Sheet2!B20 (or you can enter '=' sign and click on A10, then enter the plus sign and click on B20) jeff -----Original Message----- the sum from one cell on sheet1 from another cell on Click to expand... sheet2,how do you do the formula