Using the value in a cell as a cell reference in a formula? August 9, 2023 by Tarik Use INDIRECT() =SUM(INDIRECT(<start cell here> & ":" & <end cell here>))