» Summing Values from Cells in Different Sheets
CATEGORY - Summing
VERSION - All Microsoft Excel Versions
To total figures from the same cell address in different sheets:
1. Select a cell and type =SUM(.
2. Select the tab for the first sheet, January.
3. Hold the Shift key, and then select the tab for the last sheet, April.
4. Select cell B2, and then press Enter.
The formula is now =SUM(January:April!B2).

Book Store:
Recommended Books:
- Investing in Real Estate, Fourth Edition
- Understanding Financial Statements
- The Intelligent Investor: The Classic Bestseller on Value Investing
- Millionaire Real Estate Mentor : The Secrets of Financial Freedom through Real Estate Investing
- Special Edition Using Microsoft Access 2002
- Learn MS Excel 2002 VBA/XML Programming
No comments have been submitted.


