Forum Discussion
Solved
How to drag a formula with only incrementing one of the cell values
Hello, I want to drag I4 down to row 900, however I only want the cells from THIS sheet to increment by +1. I do not want the cells from the DataConstants Sheet to be incremented. Is there a way to...
- Use $ to fix this...$A$2 - Both column and row are not impacted by dragging.
Hence, in your formula wherever you have referred to DataConstants Sheet, use cell references with $.
Don't put $ against cell references of this sheet.
Hence your formula would be
=SUM(C4*DataConstants!$C$5,D4*DataConstants!$C$6,E4…....
Use $ to fix this...$A$2 - Both column and row are not impacted by dragging.
Hence, in your formula wherever you have referred to DataConstants Sheet, use cell references with $.
Don't put $ against cell references of this sheet.
Hence your formula would be
=SUM(C4*DataConstants!$C$5,D4*DataConstants!$C$6,E4…....
Hence, in your formula wherever you have referred to DataConstants Sheet, use cell references with $.
Don't put $ against cell references of this sheet.
Hence your formula would be
=SUM(C4*DataConstants!$C$5,D4*DataConstants!$C$6,E4…....
Thank you so much!