Excel - 3D Reference with Multiple Worksheets

A 3D Reference in Excel offers the capability to reference identical cells or cell ranges across multiple worksheets. The 3D reference functionality is advantageous and efficient when performing calculations on data spread across several worksheets sharing a common structure.

For example, if we have six worksheets set up the same, the formula =SUM(Sheet1:Sheet6!B5) will sum cell B5 in all six worksheets. After creating a 3D reference, you can autofill the data. In the formula, the exclamation point means you are referencing worksheets.

Chapters/Bookmarks:
0:00 Intro
0:20 Method 1 - not the best method
1:50 Method 2 - correct method
2:40 Add a worksheet
3:35 AutoFill tip to keep borders

Chris Menard's Online Training Course with a 50% off coupon is here
Over3 hours of material.

Popular Videos from Chris Menard
Add polling to Zoom Meetings
Create a PivotTable in Excel using multiple worksheets
What-If analysis in Excel with a Data Table
Insert a Word Document into a PowerPoint presentation
Excel - Conditional Formatting find duplicates on two worksheets
Microsoft Word - delete the empty or blank page at the end of your document
Sum up hours and minutes in Excel by Chris Menard
OneDrive - Sync Icons Explained for files and folders
Break-even analysis in Excel with a chart / cost-volume-profit analysis by Chris Menard

And make sure you subscribe to my channel!

-- EQUIPMENT USED ---------------------------------

-- SOFTWARE USED ---------------------------------

DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!

[altostratuss]

Thank you!! Second method was quick and easy and it helped me understand the formula better when completing my homework. Just subscribed! God bless you! :)

[roywilson]

This is a great way of referencing multiple sheets in a formula but you need to remember to ungroup the sheets immediately after completing the formula so as not to duplicate everything you do later onto multiple sheets at once. A lesson I learnt the hard way :(