Related:
- Change data from sheet1 to sheet2 by formula
- Cara memindahkan data dari sheet1 ke sheet2 dengan vba excel - How-To - Excel
- How to copy data from sheet1 to sheet2 ✓ - Forum - Excel
- Excel sheet1 to sheet2 formula - Forum - Excel
- Change data format excel - How-To - Excel
- Change data status in one same column ✓ - Forum - Excel
2 replies
Trowa
Hi Raghu,
Even thought I don't follow your calculations (A1+B1 = 1+5 = 10???), I think your are looking for the following:
Add your sheetname with a "!" before the cell in the formulabar, like this:
=Sheet1!A1+Sheet1!B1
This can also easily be done by clicking the "=" next to the formulabar, choosing the SUM function, then select the cell on the first sheet, then select your second cell and the result in the formulabar will be the same.
Hope this is what you meant.
Best regards,
Trowa
Even thought I don't follow your calculations (A1+B1 = 1+5 = 10???), I think your are looking for the following:
Add your sheetname with a "!" before the cell in the formulabar, like this:
=Sheet1!A1+Sheet1!B1
This can also easily be done by clicking the "=" next to the formulabar, choosing the SUM function, then select the cell on the first sheet, then select your second cell and the result in the formulabar will be the same.
Hope this is what you meant.
Best regards,
Trowa
Subscribe To Our Newsletter!
