Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What formula do I use to add totals between workbooks? | Excel Worksheet Functions | |||
I want to combine the totals from several workbooks to one summar | Excel Worksheet Functions | |||
How do I email Excel workbooks pages | New Users to Excel | |||
checking other pages and workbooks for repeating numbers? | Excel Discussion (Misc queries) | |||
Add totals in different files/workbooks? | Excel Worksheet Functions |