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
https://chrismenardtraining.teachable.com/p/microsoft-teams?coupon_code=50-PERCENT-OFF&product_id=4455036
Over3 hours of material.

Popular Videos from Chris Menard
Add polling to Zoom Meetings
https://www.youtube.com/watch?v=qN57sZ5qy6k
Create a PivotTable in Excel using multiple worksheets
https://www.youtube.com/watch?v=wdemm8LzzVY
What-If analysis in Excel with a Data Table
https://www.youtube.com/watch?v=y7S9ecg1wdQ
Insert a Word Document into a PowerPoint presentation
https://www.youtube.com/watch?v=3qXQ6QcM1CU
Excel - Conditional Formatting find duplicates on two worksheets
https://www.youtube.com/watch?v=VhECzNIQTIY
Microsoft Word - delete the empty or blank page at the end of your document
https://www.youtube.com/watch?v=fQRyUi-tuyo
Sum up hours and minutes in Excel by Chris Menard
https://www.youtube.com/watch?v=7sZUwBod-Uw
OneDrive - Sync Icons Explained for files and folders
https://www.youtube.com/watch?v=F1KnGHm2nK4
Break-even analysis in Excel with a chart / cost-volume-profit analysis by Chris Menard
https://www.youtube.com/watch?v=1BDLh1jbB7U

And make sure you subscribe to my channel!

-- EQUIPMENT USED ---------------------------------
○ My camera – https://amzn.to/3vdgF5E
○ Microphone - https://amzn.to/3gphDXh
○ Camera tripod – https://amzn.to/3veN6Rg
○ Studio lights - https://amzn.to/3vaxyy5
○ Dual monitor mount stand - https://amzn.to/3vbZSjJ
○ Web camera – https://amzn.to/2Tg75Sn
○ Shock mount - https://amzn.to/3g96FGj
○ Boom Arm - https://amzn.to/3g8cNi6

-- SOFTWARE USED ---------------------------------
○ Screen recording – Camtasia – https://chrismenardtraining.com/camtasia
○ Screenshots – Snagit – https://chrismenardtraining.com/snagit
○ YouTube keyword search – TubeBuddy – https://www.tubebuddy.com/chrismenard

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!