Rahim needs a solution: “When I change the date, I need it to Sum all of the figures of that region – SUMIF is not working.” Using =MATCH, =SUMIF, =OFFSET, =INDEX and more, Mike “ExcelisFun” Girvin and Bill “MrExcel” Jelen come up with Formula based solutions to reach a solution for Rahim. Follow along with Episode #1707 and see how you can Sum a Range as Data is changed.


Dueling Excel Podcast #123…This episode is the video podcast companion to the book, “Slaying Excel Dragons: A Beginners Guide to Conquering Excel’s Frustrations and Making Excel Fun“, by Mike Girvin and Bill Jelen. [Currently available in eBook / Print Edition and as a DVD Bundle]


“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!


35% More Tips than the previous edition of Bill’s book!

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!