SUMIF with INDIRECT Function for Dynamic Sheet and Table References

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 - https://bit.ly/UltimateExcel 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 cell value. This technique can easily be adapted for any formula - VLOOKUP, COUNTIF, INDEX - the options are endless. Find more great free tutorials at; https://www.computergaga.com *** Online Excel Courses *** Excel VBA for Beginners ► http://bit.ly/2JvnnRv Advanced Excel Tricks ► https://bit.ly/3CGCm3M Excel Formulas Made Easy ► http://bit.ly/2t3netw The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2viGg3J Connect with us!