» Summing data from a cell in a number of sheets in Microsoft Excel

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).

1. Select the sheet in which you want to enter the formula.
2. Type =SUM(.
3. Select the tab for the first sheet, January.
4. Press Shift, and select the tab for the last sheet, April.
5. Select Cell B2.
6. Press Enter.