Uploaded October 2015 | Updated September 2026, 2 hours ago

---

Get Excel file 00139 here: http://1drv.ms/1bYwrTa
Read my blog post here: bit.ly/1hEISfF

A review of Excel's 3D formulas and then some hefty formulas that go beyond the limitations of 3D formulas. Excel formulas can do magic but it does require careful set-up.

(00:11) Data layout
(01:54) Basic 3D range
(03:26) Countif 3D range
(06:46) Countif 3D range with improved sheet toggle
(12:44) Countif 3D range with improved sheet toggle and with dynamic range!

Cheers,
Kevin Lehrbass
twitter.com/kevinlehrbass
myspreadsheetlab.com/blog
myspreadsheetlab.com/video-00139-beyond-3d-formulas