Tip Printed from ExcelTip.com
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.