Forum Discussion

Gizmo2255's avatar
Gizmo2255
Copper Contributor
Jan 09, 2021

Formula automatically adjusts to grab the next cell below

How do I program a formula to grab the next cell below so that it automatically includes that cell in the formula recalculation.  Ex) =SUM(M522+H525)-G525  Where when I insert a new row below with new data, the formula will know to go to M523 for the recalculation.  

excel

4 Replies

  • adversi's avatar
    adversi
    Iron Contributor
    Jan 09, 2021

    Gizmo2255 

    Can you provide some more information on the formula adjustment? Sharing a sample workbook, without any sensitive data, of what the current formula generates and what the adjusted solution should be will help 

    • Gizmo2255's avatar
      Gizmo2255
      Copper Contributor
      Jan 09, 2021

      adversi 

      Looking for a way for the cell shown highlighted to drop down to the next cell, $534, when I enter that data.  

      • adversi's avatar
        adversi
        Iron Contributor
        Jan 10, 2021

        Gizmo2255 The image doesn't provide much help on my end. If you can, attach the workbook or just a sheet that replicates the formulas you have to make it easier to understand

    • Jihad Al-Jarady's avatar
      Jihad Al-Jarady
      MCT
      Jan 09, 2021

      Gizmo2255 

      If you copy your formula, the cell references will change automatically.

      so, if  wrote your formula in  L522 =SUM(M522+H525)-G525 and you copy the formula to L523, they formula will be =SUM(M523+H526)-G526, this is called absolute references in excel

       

Resources