Excel In Depth - 3D References: Podcast #1253

Loading...

Sign in or sign up now!
Alert icon
Upgrade to the latest Flash Player for improved playback performance. Upgrade now or more info.
2,881
Loading...
Alert icon
Sign in or sign up now!
Alert icon

Uploaded by on Sep 27, 2010

A 3-D Reference (also known as a 'Spearing Formula') is when you need to shoot through a series of worksheets to add up the same cell on many worksheets. Episode #1253 shows you how to create these references in just a few clicks!

...This episode is the video podcast companion to the book, "Excel 2010 In Depth", by Bill Jelen a.k.a. MrExcel. For all of your Microsoft Excel needs visit MrExcel.com - Your One Stop for Excel Tips and Solutions.

Category:

Howto & Style

Tags:

License:

Standard YouTube License

  • likes, 0 dislikes

Link to this comment:

Share to:
see all

All Comments (2)

Sign In or Sign Up now to post a comment!
  • I found the issue. The tab names need to be enclosed by '. i.e., =SUM('Project A:Project D'!B4)

  • It seems that if the tab names have spaces in them, this formula does not work.

Loading...

Alert icon
0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more