Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 160
Default adding totals on different pages in different workbooks

I have a different workbook for each Quarter of work, i.e. Sept, Dec,
Mar...and I need to Total the Quarters together. I know how to add totals
from different sheets in the same workbook, but can I total different pages
of different workbooks?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,389
Default adding totals on different pages in different workbooks

Just preceed with the sheet name, as in Sheet1!A1.

The best way to create formulas is to let Excel do it. Press the equal sign,
then navigate to the cell you want to start with. Excel will enter its
address. Then hit an operator (like +) and go to the next cell. You can keep
going, and create a formula without ever having to type in a cell address.

Regards,
Fred.

"Patrick" wrote in message
...
I have a different workbook for each Quarter of work, i.e. Sept, Dec,
Mar...and I need to Total the Quarters together. I know how to add totals
from different sheets in the same workbook, but can I total different
pages
of different workbooks?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
What formula do I use to add totals between workbooks? Jodi @ Tehachapi Unified Excel Worksheet Functions 0 October 4th 06 08:25 PM
I want to combine the totals from several workbooks to one summar ithappens Excel Worksheet Functions 0 December 15th 05 12:25 AM
How do I email Excel workbooks pages Paula New Users to Excel 2 September 28th 05 01:12 PM
checking other pages and workbooks for repeating numbers? Done Right Excel Discussion (Misc queries) 0 July 24th 05 01:01 PM
Add totals in different files/workbooks? Roger Excel Worksheet Functions 1 December 5th 04 10:12 AM


All times are GMT +1. The time now is 08:37 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"