» Summing Values from Different Sheets for the Same Cell Address
CATEGORY - Excel Summing
VERSION - All Microsoft Excel Versions
Summing the values from cell A1 of four successive sheets in the current workbook.
The sheets are named January, February, March, and April.
Solution:
1. Select a cell to contain the sum and type =SUM(
2. Select the tab of the first sheet to sum (January).
3. Hold the
4. Select the cell to sum (A1).
5. Type ) and
These actions will create the following formula, which sums the same cell (A1) from all four sheets:
=SUM(January:April!A1)
Book Store:
Recommended Books:
- Financial Statement Analysis with S&P insert card
- Positioning: The Battle for Your Mind
- The New Financial Order: Risk in the Twenty-First Century
- Microsoft Windows XP Inside Out
- Lower Your Taxes - Big Time! : Wealth-Building, Tax Reduction Secrets from an IRS Insider
- Learn MS Excel 2002 VBA/XML Programming
No comments have been submitted.
