how do I merge total from many pages into one main page in excel?

G

Gord Dibben

=SUM(sheet1:sheet125!A1)

If sheets have unique names...........

Add a new dummy sheet after the Summary sheet which I assume is first in book.

Name this sheet Start.

Add a new dummy sheet at end of book and name it End

On Summary sheet =SUM(Start:End!A1)

Any new sheets will inserted between Start and End


Gord Dibben Excel MVP

On Thu, 5 May 2005 18:49:01 -0700, JER <[email protected]> wrote:
 

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

How do I get info from one sheet to autopopulate into all sheets? 0
How do i collate data from different sheets in one sheet? 8
how do I import an excel file into quicken? 0
How do I link info from a key sheet to drop down lists in Excel? 0
How do I increase the number of columns in excel above 256 0
how do I use a cells from one worksheet in the equation of another 1
How do I change default worksheet colour from white? 1
Code for Inserting Sheet in Excel 2000 not working in 2003 1

Top