Summing Multiple Worksheets (Tabs) in Excel


If you are consolidating multiple structurally identical worksheets (tabs) in Excel, say to roll-up various product line financials for a business unit, you may have manually linked each tab via a formula that follows:

=Sheet1!B2+Sheet2!B2+Sheet3!B2+Sheet4!B2 ,or


Instead you could define the range of sheets to sum, such as:


The attached workbook and video walk through this process.

Download the Excel Workbook here.

If you had tabs labelled Jan through Dec, you could simply just use this formula:


In my example above, blank dummy tabs were added that were names “<” and “>” – these dummy tabs can be named anything, but I find “<“, and “<<“, and “<<<” for different sequences of summed looks good in the formulas.

©2018 Ben Etzkorn



Please enter your comment!
Please enter your name here

This site uses Akismet to reduce spam. Learn how your comment data is processed.