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
And finally, in cell B5 of the Summary Sheet is the formula
that sums the range of Expenses on each quarterly worksheet from Sheet1 to Sheet4.