•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How to drag down a formula and increase a number(s) within that formula
So my formula is as follows
=SUM(IF(Table_1[Est. No.]=$C$4, Table_1[Final QTY],0))
When I drag down I need to Table value to increase by one. So Table_1 will then become Table_2 and I need it to do it for both times it’s referenced in the formula. I have 250 of these to do and I don’t feel like doing copy, paste and edit
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#AI formula generation techniques
#Excel alternatives for data analysis
#rows.com
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#formula
#Table_1
#Excel
#SUM
#IF
#drag down
#increase
#Est. No.
#Final QTY
#Table_2
#reference
#formula dragging
#copy
#paste