Published On Jan 14, 2019
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