Cassie Karilynn

Excel 2024 Indirect. The indirect excel function indirectly refers to cells, cell ranges, worksheets, and workbooks. This function allows you to create dynamic references to cells,.

The formula above reduces to =sum(indirect(d3:d6)). To use the indirect function in excel, follow these steps: