how do I get a total for all worksheets in my workbook?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have ten worksheets, each with a total. How do I get a total of all totals?
 
Considering you have 3 sheets, and the totals are in cell A1, then use:
=SUM(Sheet1:Sheet3!A1)

Mangesh



Aileen Hewat said:
I have ten worksheets, each with a total. How do I get a total of all
Click to expand...
totals?
 
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 said:
I have ten worksheets, each with a total. How do I get a total of all
Click to expand...
totals?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Functions for all worksheets 4
Merge data from different worksheets 3
Total Adblocker 4
Summarizing monthly worksheet totals 1
Running Sum of cell in many spreadsheets 1
auto update to multiple worksheets 2
Excel VBA - counting cells by colors and names to it in two different rows. 0
Summary Sheet Totals 7

Back
Top