ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Basic example formula needed to link between sheets add/subtract (https://www.excelbanter.com/new-users-excel/171366-basic-example-formula-needed-link-between-sheets-add-subtract.html)

gnagy84

Basic example formula needed to link between sheets add/subtract
 
I've tired =j6+g21 but from different sheets, so its possible when i change
one the other changes also. What formula do I need, because thats just not
working

David Biddulph[_2_]

Basic example formula needed to link between sheets add/subtract
 
Type the = sign, then go to the other sheet and click in J6, then hit the +
sign, and go to the relevant sheet and click in G21. Hit enter.
You should have a formula that looks something like
=Sheet2!J6+Sheet3!G21
--
David Biddulph
"gnagy84" wrote in message
...
I've tired =j6+g21 but from different sheets, so its possible when i
change
one the other changes also. What formula do I need, because thats just not
working





All times are GMT +1. The time now is 08:58 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com