| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to summarise information from 4 work sheets
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to summarise information from 4 work sheets
Can be done but need more details like what is to be summarized and where is it
to be placed. A typical 3-d reference formula for example is............. =SUM(Sheet1:Sheet5!A1) which will sum all A1's on 5 sheets. Gord Dibben MS Excel MVP On Mon, 18 Jun 2007 01:00:03 -0700, black_magic wrote: I am trying to create a worksheet which is a summary of the information in 5 other worksheets. I would like the computer to automaticly sumarise this information. Can it be done? and if so how? I am in work an cannot access my hotmail account. please reply to |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Merge information from different sheets in to 1 | Excel Discussion (Misc queries) | |||
| Counting dates in multiple work sheets and work books | Excel Discussion (Misc queries) | |||
| Important information on 2 sheets, combine? | Excel Discussion (Misc queries) | |||
| I wish to save my Excell work in my work sheets | Excel Worksheet Functions | |||
| Summarise data on multiple sheets | Excel Worksheet Functions | |||
Linear Mode
