| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how do I get a total for all worksheets in my workbook?
I have ten worksheets, each with a total. How do I get a total of all totals?
|
|
#2
|
|||
|
|||
|
Considering you have 3 sheets, and the totals are in cell A1, then use:
=SUM(Sheet1:Sheet3!A1) Mangesh "Aileen Hewat" wrote in message ... I have ten worksheets, each with a total. How do I get a total of all totals? |
|
#3
|
|||
|
|||
|
This file might be a help:
http://www.bygsoftware.com/examples/zipfiles/consol.zip It's in the "Accountants" section on page: http://www.bygsoftware.com/examples/examples.htm The "Bread-Roll" consolidation method - great for accountants. See how simple it is to consolidate any combination of your organisation's accounts. (No VBA used) -- Andy Wiggins FCCA www.BygSoftware.com Excel, Access and VBA Consultancy - "Aileen Hewat" wrote in message ... I have ten worksheets, each with a total. How do I get a total of all totals? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| grand total column B from every worksheet in workbook | Excel Discussion (Misc queries) | |||
| total same cell in all worksheets | Excel Worksheet Functions | |||
| Protect/unprotect all worksheets | Excel Worksheet Functions | |||
| Countif with multiple criteria and multiple worksheets | Excel Worksheet Functions | |||
| Totalling Separate Worksheets | Excel Worksheet Functions | |||
Linear Mode
