| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how do I merge total from many pages into one main page in excel?
|
|
#2
|
|||
|
|||
|
=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 wrote: |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Different graphic for each record in mail merge document | Charts and Charting in Excel | |||
| How do I do an excel merge like a word mailmerge with another exc. | Excel Discussion (Misc queries) | |||
| Merge Pages for printing | Excel Worksheet Functions | |||
| Total remaining formula | Excel Worksheet Functions | |||
| Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions | |||
Linear Mode
