| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
summing across worksheets
I have a workbook with 80 worksheets. I want to add column E12 thru column
E50 across all worksheets, then total up those numbers. Any ideas if this is possible? Thanks, Todd |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
summing across worksheets
try this. Best to set up a dummy 1st and last sheet so that if you
add/delete sheets, OK =SUM(Sheet1:Sheet80!e12:e50) -- Don Guillett Microsoft MVP Excel SalesAid Software "Todd Hudson" wrote in message ... I have a workbook with 80 worksheets. I want to add column E12 thru column E50 across all worksheets, then total up those numbers. Any ideas if this is possible? Thanks, Todd |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
summing across worksheets
Also note that Sheets 2 - 79 must be physically located between Sheets 1 & 80 for this to work.
-- Cheers macropod [Microsoft MVP - Word] "Don Guillett" wrote in message ... try this. Best to set up a dummy 1st and last sheet so that if you add/delete sheets, OK =SUM(Sheet1:Sheet80!e12:e50) -- Don Guillett Microsoft MVP Excel SalesAid Software "Todd Hudson" wrote in message ... I have a workbook with 80 worksheets. I want to add column E12 thru column E50 across all worksheets, then total up those numbers. Any ideas if this is possible? Thanks, Todd |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Summing Across Worksheets | Excel Discussion (Misc queries) | |||
| Summing across Worksheets | Excel Worksheet Functions | |||
| Summing up worksheets | Excel Worksheet Functions | |||
| Summing across several worksheets | Excel Discussion (Misc queries) | |||
| SUMMING COLUMNS IN DIFFERENT WORKSHEETS | Excel Discussion (Misc queries) | |||
Linear Mode
