SUMIF with INDIRECT Function for Dynamic Sheet and Table References

>> YOUR LINK HERE: ___ http://youtube.com/watch?v=OM4MAaQ4oN0

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! • LinkedIn ► / 18737946 • Instagram ► / computergaga1 • Twitter ► / computergaga1

#############################

New on site