» 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
- Seven Habits Of Highly Effective People
- The Total Money Makeover. : A Proven Plan for Financial Fitness
- The Guide to Understanding Financial Statements
- The McGraw-Hill 36-Hour Course in Finance for Nonfinancial Managers
- How to Use Financial Statements: A Guide to Understanding the Numbers
No comments have been submitted.
