Formula automatically adjusts to grab the next cell below

%3CLINGO-SUB%20id%3D%22lingo-sub-2045654%22%20slang%3D%22en-US%22%3EFormula%20automatically%20adjusts%20to%20grab%20the%20next%20cell%20below%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2045654%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20do%20I%20program%20a%20formula%20to%20grab%20the%20next%20cell%20below%20so%20that%20it%20automatically%20includes%20that%20cell%20in%20the%20formula%20recalculation.%26nbsp%3B%20Ex)%26nbsp%3B%3CSPAN%3E%3DSUM(%3C%2FSPAN%3E%3CSPAN%3EM522%3C%2FSPAN%3E%3CSPAN%3E%2B%3C%2FSPAN%3E%3CSPAN%3EH525%3C%2FSPAN%3E%3CSPAN%3E)-%3C%2FSPAN%3E%3CSPAN%3EG525%26nbsp%3B%20Where%20when%20I%20insert%20a%20new%20row%20below%20with%20new%20data%2C%20the%20formula%20will%20know%20to%20go%20to%20M523%20for%20the%20recalculation.%26nbsp%3B%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2045654%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2045724%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20automatically%20adjusts%20to%20grab%20the%20next%20cell%20below%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2045724%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F923267%22%20target%3D%22_blank%22%3E%40Gizmo2255%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20you%20provide%20some%20more%20information%20on%20the%20formula%20adjustment%3F%20Sharing%20a%20sample%20workbook%2C%20without%20any%20sensitive%20data%2C%20of%20what%20the%20current%20formula%20generates%20and%20what%20the%20adjusted%20solution%20should%20be%20will%20help%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2045855%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20automatically%20adjusts%20to%20grab%20the%20next%20cell%20below%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2045855%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F923267%22%20target%3D%22_blank%22%3E%40Gizmo2255%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20copy%20your%20formula%2C%20the%20cell%20references%20will%20change%20automatically.%3C%2FP%3E%3CP%3Eso%2C%20if%26nbsp%3B%20wrote%20your%20formula%20in%26nbsp%3B%20L522%20%3DSUM(M522%2BH525)-G525%20and%20you%20copy%20the%20formula%20to%20%3CSTRONG%3EL523%3C%2FSTRONG%3E%2C%20they%20formula%20will%20be%26nbsp%3B%3CSTRONG%3E%3DSUM(M523%2BH526)-G526%3C%2FSTRONG%3E%2C%20this%20is%20called%20absolute%20references%20in%20excel%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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.  

4 Replies

@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 

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

 

@adversi 

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

@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