The INDIRECT function, as its name suggests, can be used to indirectly reference a cell in a worksheet.
This is done by entering a cell reference as text string into the cell that is being read by the function.
INDIRECT converts this text string into a real cell reference, and then reads and displays the contents of this new cell.
Like many other Excel functions, on its own INDIRECT has limited usefulness. It is most effective when combined with other functions to create more complex formulas.
INDIRECT can be used with a number of functions that accept a cell reference as an argument, such as the SUM Function.
By combining the two, you can create a formula that lets you dynamically adjust the range of the SUM function without having to edit the formula itself.
To find out all the details of using this function, read this tutorial on the Excel INDIRECT Function.Related Tutorials