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