Excel's INDIRECT function turns a text string into a reference ... In this example, typing =SUM(INDIRECT(A2)) into cell B2 first turns A2 into a cell reference, and then sums the cells in that ...