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 do this?
Thanks
- 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…....
2 Replies
- 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…....- Thank you so much!