» 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:
- Preparing the Marketing Plan (Ama Marketing Toolbox Series New Edition)
- The Ernst & Young Business Plan Guide
- Keys to Reading an Annual Report (Barron's Business Keys)
- Microsoft Office XP Step-By-Step (With CD-ROM)
- What the IRS Doesn't Want You to Know: A Cpa Reveals the Tricks of the Trade
- Windows XP Pocket Reference
No comments have been submitted.
