Tom’s Tutorials For Excel: Summing Cells Across Worksheets

Tom’s Tutorials For Excel: Summing Cells Across Worksheets

Here are formulas that sum numbers in a single cell, and in a range of cells, across multiple worksheets. The first picture shows a section from four different worksheets, each displaying Income and Expenses for their respective Quarter.

The next picture shows how a single cell is summed for all worksheets from Sheet1 to Sheet4.
The formula in cell B3 on the Summary Sheet is =SUM(Sheet1:Sheet4!B3).

And finally, in cell B5 of the Summary Sheet is the formula =SUM(Sheet1:Sheet4!B6:B10)
that sums the range of Expenses on each quarterly worksheet from Sheet1 to Sheet4.