| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sum one cell from multiple worksheets
Thank you both for the assistance!!!
"Gord Dibben" wrote: =SUM(Sheet1:Sheet11!A1) If your sheets have unique names, insert a new dummy sheet at beginning. Name it Start. Insert another dummy sheet at end. Name it End. =SUM(Start:End!A1) will cover all sheets in between no matter what the name. Gord Dibben MS Excel MVP On Wed, 23 Aug 2006 12:39:02 -0700, abrusey wrote: Hello! Does anyone know of a quick way to sum one cell (for ex. A1) for all worksheets in the workbook (say there are 10 total + 1 Summary worksheet) on the summary worksheet? Please let me know if the question needs additional clarification. thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compile list of same cell from multiple worksheets | Excel Worksheet Functions | |||
| 1 cell average across multiple worksheets | Excel Worksheet Functions | |||
| How do I stop worksheets from duplicating cell in a different wor. | Excel Discussion (Misc queries) | |||
| Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
| how do I sum the same cell from multiple worksheets? | Excel Worksheet Functions | |||
Hybrid Mode
