Excel query

[Gonzague]

Work based query which is driving me mad.

I have a spreadsheet with various tabs on and want to get the key figures from each to come up with an overall calculation from each tab

e.g A10 on tab 2 + B15 on tab 3 etc.

Is there any way of doing this?

Cheers

Gonz

[murf]

Yes, just if doing it on tab 3 start setting up the equation as B15+ then click tab 2 and then click square A10

=b15+Sheet2!A10

[djnuttie]

In the cell where you want the result to appear type '=' then click on the first relevant tab and cell then type '+' then move onto the next tab/cell and continue. When finished press return.

Good Luck

[Gonzague]

Cheers lads! Quick response and quick solution!