TheINDIRECT functionautomatically updates the range of cells you’ve referenced without manually editing the formula itself.
The INDIRECT function does this by referencing the range of cells indirectly, through an intermediate cell reference.
you’re able to also use other cells in the spreadsheet to modify the cell references.
Try the SUM and INDIRECT Functions
Create a spreadsheet to test the SUM and INDIRECT functions yourself.
To see the INDIRECT function in action, insert a new cell into cell D3.
This shifts all of the other cells down.
The new sum is the total of cells D3 to D7.
The #REF!
Error Value
The #REF!error valueappears in cell F1 if the INDIRECT function:
