| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
getting a sum across multiple worksheets, then adding the numbers
Hi,
In your summary sheet, in cell E12 enter: =Sheet2:Sheet80!E12 Copy this formula down to E50. In cell E51 enter =SUM(E12:E50) -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Todd Hudson" wrote: 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding a Row to Multiple Worksheets at Once | Excel Worksheet Functions | |||
| Adding multiple worksheets | Excel Worksheet Functions | |||
| Adding numbers from several worksheets with a common bond | Excel Worksheet Functions | |||
| Adding multiple worksheets | Excel Worksheet Functions | |||
| adding certain cells in multiple worksheets in multiple workbooks | Excel Worksheet Functions | |||
![Shane Devenshire[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
