» 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:
- The Financial Numbers Game: Detecting Creative Accounting Practices
- Microsoft Excel 2002 Formulas (With CD-ROM)
- Real Estate Finance and Investments (Real Estate Finance and Investments, 11th Ed)
- Microsoft Excel VBA Programming for the Absolute Beginner
- Understanding Financial Statements
- Business Analysis and Valuation: Using Financial Statements, Text and Cases
No comments have been submitted.
