| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Basic IF function help needed | New Users to Excel | |||
| Multiply two colums; BASIC help needed | New Users to Excel | |||
| Word Doc w/2 Excel Sheets - need formula to link them | Excel Discussion (Misc queries) | |||
| Comparison / Check Off between 2 excel sheets. HELP NEEDED! | Excel Worksheet Functions | |||
| CAN I LINK FILES TO PRINT TOGETHER WHEN NEEDED | Excel Discussion (Misc queries) | |||
Linear Mode
