Basic example formula needed to link between sheets add/subtract

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

gnagy84 - 02 Jan 2008 17:17 GMT

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 to this Message

David Biddulph - 02 Jan 2008 17:44 GMT

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

Signature

David Biddulph

> 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 to this Message