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 |
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