Skip to main content

Create Sum that gives summary of all Worksheets in Excel

 You have a workbook with 12 worksheets, 1 for each month. All of the worksheets have the same number of rows and columns. You want a summary worksheet in order to total January through December.

To create it, use the formula =SUM(January:December!B4).

After sheets for January through December, a new Summary worksheet is shown. The formula =SUM(January:December!B4) is in B4.

Copy the formula to all cells and you will have a summary of the other 12 worksheets.

Copy the formula throughout the worksheet and you will have a report adding up the similar cell on the 12 monthly worksheets.

Caution

I make sure to never put spaces in my worksheet names. If you do use spaces, the formula would have to include apostrophes, like this: =SUM('Jan 2018:Mar 2018'!B4).

Labels:

Comments

Post a Comment