•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Increment row but not column when copying a formula?
Trying to fix an old spreadsheet at work. The current formula is this:
=SUM(R6,R16,R26,R36,R46,R56)
I need to build 4 more columns to the right of the existing one with the same formula, that increments the row but leaves the column the same, like this:
=SUM(R7,R17,R27,R37,R47,R57)
I don't think I can use $ for this as that always locks the column right?
Photo Example below.
I need to add three more Flav columns on the right hand side, pulling from lists like on the left hand side.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com