» Summing Values from Cells in Different Sheets
CATEGORY - Summing
VERSION - All Microsoft Excel Versions
In this example, we have a workbook with four successive sheets: January, February, March and April.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:
- Quantitative Methods in Derivatives Pricing: An Introduction to Computational Finance
- The McGraw-Hill Guide to Writing a High-Impact Business Plan: A Proven Blueprint for First-Time Entrepreneurs
- Accounting and Financial Fundamentals for Nonfinancial Executives
- F1 Get the Most out of Excel! The Ultimate Excel tip Help Guide
- Financial Statement Analysis with S&P insert card
- Absolute Beginner's Guide to Microsoft Office Excel 2003
No comments have been submitted.
