Excel 2024 Indirect. This tutorial demonstrates how to use the excel indirect function in excel and google sheets to create a cell reference from text. The formula above reduces to =sum(indirect(d3:d6)).
If a worksheet has a space in the name, you must build the reference to the. Mastering the indirect function in excel can open up a whole new world of possibilities for your spreadsheets.