SOLVED

How to drag a formula with only incrementing one of the cell values

Copper Contributor

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?
SteveDatz_0-1647276365998.png

Thanks

2 Replies
best response confirmed by SteveDatz (Copper Contributor)
Solution
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…....
1 best response

Accepted Solutions
best response confirmed by SteveDatz (Copper Contributor)
Solution
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…....

View solution in original post