» Summing data from a cell in a number of sheets in Microsoft Excel
CATEGORY - Summing
VERSION - All Microsoft Excel Versions
Sum a single cell from a number of sheets.
For example: A workbook has four successive sheets. The names of the sheets are January, February, March and April.
The formula: =SUM(January:April!B2).
- Select the sheet in which you want to enter the formula.
- Type =SUM(.
- Select the tab for the first sheet, January.
- Press Shift, and select the tab for the last sheet, April.
- Select Cell B2.
- Press Enter.
Book Store:
Recommended Books:
- Keys to Reading an Annual Report (Barron's Business Keys)
- The Fall of Advertising and the Rise of PR
- Microsoft Excel Version 2002 Step by Step
- Infectious Greed: How Deceit and Risk Corrupted the Financial Markets
- Rich Dad's Guide to Investing: What the Rich Invest in, That the Poor and the Middle Class Do Not!
- The Interpretation of Financial Statements
No comments have been submitted.
