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!

LinkedIn ►   / 18737946  
Instagram ►   / computergaga1  
Twitter ►   / computergaga1