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.
I found the issue. The tab names need to be enclosed by '. i.e., =SUM('Project A:Project D'!B4)
Jazzgal0515 1 month ago
It seems that if the tab names have spaces in them, this formula does not work.
Jazzgal0515 1 month ago