Summing Values from Cells in Different Sheets





In this example, we have a workbook with four successive sheets: January, February, March and April.

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).
Screenshot // Summing Values from Cells in Different Sheets
Summing Values from Cells in Different Sheets



One thought on “Summing Values from Cells in Different Sheets

Leave a Reply

Your email address will not be published. Required fields are marked *


one + 2 =

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>