Excel Sheets 2

[Policekauk]

How can I create a sheet (Summary Page say for example)that can communicate with the 17 sheets in my spread? I want it to retrive information from the total columns of all the others.


Thanks

 

[fneily]

So you want to add up all the other totals? Select a cell in your summary sheet where you want the sum to go. Then type an equal(=) sign. Then click on a sheet and click on the data you want. Then type a plus (+) sign. Click on the next sheet, click the data, type a plus sign, etc. etc. When you have selected the last piece of data, hit Enter.

 

[AnotherHiggins]

Let's say the first sheet you want added is named "First" and the last is named "Last". Then you can use:
=sum(First:Last!A1) and it will sum cell A1 on each sheet between the two named sheets. The summary sheet cannot be between the first and last sheet.

NOTE: it would be best to change your whole approach. Keep all like-data in a single table and query out whatever portions you want.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.