Using the value in a cell as a cell reference in a formula ?

Using the value in a cell as a cell reference in a formula ?

Asked on January 11, 2019 in Excel.
Add Comment


  • 1 Answer(s)

    By utilizing INDIRECT() method for using the value in a cell as a cell reference in a formula :

    =SUM(INDIRECT(<start cell here> & ":" & <end cell here>))
    
    Answered on January 11, 2019.
    Add Comment


  • Your Answer

    By posting your answer, you agree to the privacy policy and terms of service.