Summing Multiple Worksheets (Tabs) in Excel

0
137

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

=SUM(Sheet1!B2,Sheet2!B2,Sheet3!B2,Sheet4!B2)

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

=SUM(‘<:>’!B2)

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:

=sum(‘Jan:Dec’!ColRow)

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

LEAVE A REPLY

Please enter your comment!
Please enter your name here

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