ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   adding totals on different pages in different workbooks (https://www.excelbanter.com/excel-worksheet-functions/183735-adding-totals-different-pages-different-workbooks.html)

Patrick

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?

Fred Smith[_4_]

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?




All times are GMT +1. The time now is 05:30 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com