MrExcel's Learn Excel #974 - NonContiguous Spearing

Tags:: Excel Business Accounting Spreadsheets Tutorials Technology Mrexcel Formula 3D

Edit Video Details

Share
Add to Favorites
Report
Download

By: MrExcel
Subscribers: 11
Updated: 21-Dec-09
Videos: 232

International
Comments: 0
Views: 2,227
Added: 19-Mar-09

You may have seen how to create a spearing or 3-D formula such as =SUM(Jan:Dec!B3). In Episode 974, an amazing way to create a 3D reference to non-contiguous sheets.

This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!