In this example, we have a workbook with four successive sheets: January, February, March and April.
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).
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment