To see less ads Register or Login ----- Daily Fantasy Sports games 18+

Excel query

A forum to discuss or share knowledge of spreadsheets.
Post Reply
User avatar
Gonzague
FISOhead
Posts: 654
Joined: 02 Jan 2008, 17:12

Excel query

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

User avatar
murf
FISO Viscount
Posts: 109450
Joined: 13 Oct 2005, 18:28
Location: here
FS Record: Once led TFF. Very briefly.
Contact:

Re: Excel query

Post by 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
Last edited by murf on 09 Apr 2009, 13:37, edited 1 time in total.

User avatar
djnuttie
Dumbledore
Posts: 5333
Joined: 03 Jun 2006, 11:22
Location: Rising from the ashes...
Contact:

Re: Excel query

Post by 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 :D

User avatar
Gonzague
FISOhead
Posts: 654
Joined: 02 Jan 2008, 17:12

Re: Excel query

Post by Gonzague »

Cheers lads! Quick response and quick solution!

View Latest: 1 Day View Your posts
Post Reply

Return to “Spreadsheets”