define the indirect function in excel
Excel SUM and INDIRECT Dynamic Range Formula SUM - INDIRECT Formula Overview. Using the INDIRECT function in Excel formulas makes it easy to change the range of cell references used in the formula without having to edit the formula itself. INDIRECT can be used with a number of functions that accept a cell reference as an argument such as the OFFSET and SUM functions. In the latter case, using INDIRECT as the argument for the SUM function can create a dynamic range of cell references that the SUM function then adds up.