| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum same cell/range of multiple worksheets within a workbook...
I am trying to sum a cell from multiple worksheets within a workbook to
receive a total of all the worksheets. Isn't there a way to do this without selecting each worksheet cell (i.e. sum(worksheet1'!A1, worksheet2'!A1, ...)? -- thanks, geld |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sum same cell/range of multiple worksheets within a workbook...
Same cell in each worksheet?
If yes, then insert a couple of worksheets to surround your existing worksheets. Call the one at the far Left, "Start" (w/o the quotes). Call the one at the far right, "End" (w/o the quotes). Then put the total sheet outside that "sandwich" of worksheets. And use a formula like: =sum(Start:End!a1) You can drag sheets in and out of that sandwich to play what-if games. geld wrote: I am trying to sum a cell from multiple worksheets within a workbook to receive a total of all the worksheets. Isn't there a way to do this without selecting each worksheet cell (i.e. sum(worksheet1'!A1, worksheet2'!A1, ...)? -- thanks, geld -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sum same cell/range of multiple worksheets within a workbook...
=SUM(Sheet1:Sheet3!A1)
Adjust to suit "geld" wrote: I am trying to sum a cell from multiple worksheets within a workbook to receive a total of all the worksheets. Isn't there a way to do this without selecting each worksheet cell (i.e. sum(worksheet1'!A1, worksheet2'!A1, ...)? -- thanks, geld |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sum same cell/range of multiple worksheets within a workbook..
Thanks for the help... I actually remembered how to complete this task just
after posting, but I do appreciate the prompt responses. -- thanks, geld "Teethless mama" wrote: =SUM(Sheet1:Sheet3!A1) Adjust to suit "geld" wrote: I am trying to sum a cell from multiple worksheets within a workbook to receive a total of all the worksheets. Isn't there a way to do this without selecting each worksheet cell (i.e. sum(worksheet1'!A1, worksheet2'!A1, ...)? -- thanks, geld |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Print all charts in a workbook (multiple worksheets) | Charts and Charting in Excel | |||
| Open multiple files into multiple worksheets of the same workbook | Excel Discussion (Misc queries) | |||
| Linking between multiple worksheets, workbooks and columns | Excel Discussion (Misc queries) | |||
| How to search multiple worksheets in a workbook for information? | Excel Discussion (Misc queries) | |||
| How do I double-side print multiple worksheets in a workbook? | Excel Discussion (Misc queries) | |||
Linear Mode
