SUMIF with INDIRECT Function for Dynamic Sheet and Table References HD

In this video we look at using the SUMIF function with the INDIRECT function for dynamic worksheet and table references. Learn it all with the Ultimate Excel Course for just $10.99 - http://bit.ly/2LVuHDW Two amazing functions used together to sum values from a sheet specified as a cell value. We then use them to reference a table from a cell value. This technique can easily be adapted for any formula - VLOOKUP, COUNTIF, INDEX - the options are endless. Find more great free tutorials at; http://www.computergaga.com *** Online Excel Courses *** Excel VBA for Beginners ► http://bit.ly/2JvnnRv Advanced Excel Tricks ► http://bit.ly/2klIl6H Excel Formulas Made Easy ► http://bit.ly/2t3netw The Ultimate Excel Course – Learn Everything ► http://bit.ly/2LVuHDW Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2viGg3J Connect with us! Google+ ► https://plus.google.com/+Computergaga Facebook ► http://www.facebook.com/computergaga Twitter ► http://www.twitter.com/computergaga1