| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I show totals from sheets 2 &.3 on sheet 1
I have information on sheets 1, 2, 3,4 etc. Can I collate the totals from
each sheet on a master speread sheet 1?c |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can I show totals from sheets 2 &.3 on sheet 1
Suppose your totals are in cell D2 on each of those sheets, and that
the summary sheet is positioned either before Sheet1 or after your last sheet (i.e. not in the middle of the first and last sheets). Then you can use this formula to add them all up: =SUM(Sheet1:Sheetn!D2) where Sheetn is your last sheet in the sequence. Hope this helps. Pete On Aug 20, 8:58*pm, Chezney wrote: I have information on sheets 1, *2, 3,4 etc. *Can I collate the totals from each sheet on a master speread sheet 1?c |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Add row above TOTALS to all sheets when done in one sheet. | Excel Worksheet Functions | |||
| totals sheet- need summary of column of names between sheets | Excel Discussion (Misc queries) | |||
| Lookup values in multipul sheets and show value in another sheet | Excel Worksheet Functions | |||
| calculate totals of 5 sheets on to 6th sheet. | Excel Worksheet Functions | |||
| how do changes made on shared sheets show up in a master sheet? | Excel Worksheet Functions | |||
Linear Mode
