» Summing Values from Cells in Different Sheets
CATEGORY - Summing
VERSION - All Microsoft Excel Versions
To total figures from the same cell address in different sheets:
1. Select a cell and type =SUM(.
2. Select the tab for the first sheet, January.
3. Hold the Shift key, and then select the tab for the last sheet, April.
4. Select cell B2, and then press Enter.
The formula is now =SUM(January:April!B2).
Book Store:
Recommended Books:
- Treason: Liberal Treachery from the Cold War to the War on Terrorism
- The Fall of Advertising and the Rise of PR
- Microsoft Excel 2002 Visual Basic for Applications Step by Step
- East of Eden (Oprah's Book Club)
- Microsoft Windows XP Registry Guide
- The One Page Business Plan: Start With a Vision, Build a Company!
No comments have been submitted.
