Basic example formula needed to link between sheets add/subtract

G

gnagy84

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
 
D

David Biddulph

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autonumber field in Excel that behaves the same as Access 0
External cell reference between two excel worksheets both in One Drive 0
Semi Noob - Sheets+formulas Help 1
Need formula to automatically populate Sheet 2 cells with same content as Sheet 1 1
Word 2016 - Difficulties Learning Style Creation/Application 0
Invoicing and customer database 0
How To Rapidly Copy Formulas? 0
VBA word change keys 0

Top