» Summing Values from Different Sheets for the Same Cell Address
CATEGORY - Excel Summing
VERSION - All Microsoft Excel Versions
Problem: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:
- Lower Your Taxes - Big Time! : Wealth-Building, Tax Reduction Secrets from an IRS Insider
- Writing Excel Macros with VBA, 2nd Edition
- Windows XP All-in-One Desk Reference For Dummies
- Positioning: The Battle for Your Mind
- The McGraw-Hill Guide to Writing a High-Impact Business Plan: A Proven Blueprint for First-Time Entrepreneurs
- The New Financial Order: Risk in the Twenty-First Century
No comments have been submitted.
