An Excel INDIRECT Function Tutorial

#excel #sumifs #indirectfunction #exceltips #microsoftexcel
In this video you will learn about the Indirect Function in Excel. You will learn how to generate dynamic range references using indirect function in Microsoft Excel.
This video includes a brief mention of VLOOKUP Function & SUMIFS Function.

Chapters:
0:00 Setting the Context.
0:47 Indirect Function.
5:36 Use Indirect Function with Sum to Dynamically calculate sum from various worksheets.
8:41 Use Indirect Function with SUMIFS Function to Dynamically Sum.
14:36 Caution while using Indirect Function.