Sometimes a Pivot Table is an intermediate step on the way to something bigger. ModelOff finalist Vlad Smirnov is creating a reserve booking for risky loans at a bank. His SumProduct Formula counts on every risk class being present in every month. But that formula fails when a month doesn’t have loans that fall into all four risk classes. Today Episode #1839 shows us how to tweak the Pivot Table to force all of the risk classes to appear every month, even if there is no data.


…This blog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill’s book!

“The Learn Excel from MrExcel Podcast Series”

Visit us: for all of your Microsoft Excel Needs!


ModelOff is a worldwide championship for financial modelling in Excel. 16 finalists were flown to NYC in December 2013 to compete head-to-head. I was there as a judge and took the opportunity to record some Live Podcasts  -Bill 'MrExcel' Jelen