{"id":3862,"date":"2019-01-02T18:13:39","date_gmt":"2019-01-02T18:13:39","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=3862"},"modified":"2024-03-29T14:18:23","modified_gmt":"2024-03-29T14:18:23","slug":"range-based-on-cell-value","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/formulas\/range-based-on-cell-value\/","title":{"rendered":"Range Based on Cell Value in Excel"},"content":{"rendered":"\n
Calculating ranges is easy. But have you ever tried to calculate a range based on the number in a specific cell?<\/p>\n\n\n\n
In this lesson, I\u2019ll show you a formula where you make such a reference.<\/p>\n\n\n\n
=SUM(A1:INDIRECT(CONCATENATE(\"A\",C2)))<\/pre>\n\n\n\nThis is our result.<\/p>\n\n\n\n