•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
#AI formula generation techniques
#formula generator
#Excel alternatives for data analysis
#row zero
#rows.com
#natural language processing for spreadsheets
#modern spreadsheet innovations
#machine learning in spreadsheet applications
#generative AI for data analysis
#enterprise-level spreadsheet solutions
#digital transformation in spreadsheet software
#Excel compatibility
#collaborative spreadsheet tools
#AI-driven spreadsheet solutions
#cloud-based spreadsheet applications
#financial modeling with spreadsheets
#automation in spreadsheet workflows
#no-code spreadsheet solutions
#AI-powered spreadsheet
#Excel alternatives