•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