• Share
Send to a Friend via Email

### Your suggestion is on its way!

An email with a link to:

was emailed to:

Thanks for sharing About.com with others!

You can opt-out at any time. Please refer to our privacy policy for contact information.

# Excel INDIRECT Function

By March 2, 2014

Excel INDIRECT Function

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
Line and paragraph breaks are automatic. Some HTML allowed: `<a href="" title="">`, `<b>`, `<i>`, `<strike>`