» 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:
- The Sweet Potato Queens' Big-Ass Cookbook and Financial Planner
- Microsoft Windows XP Inside Out
- Absolute Beginner's Guide to Microsoft Excel 2002
- Financial Risk Manager Handbook, Second Edition
- The Complete Book of Business Plans: Simple Steps to Writing a Powerful Business Plan (Small Business Sourcebooks)
- Microsoft Excel 2002 Formulas (With CD-ROM)
No comments have been submitted.
