•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
Our take
If you’ve ever felt bogged down by repetitive tasks in your spreadsheets, you’re not alone. You want to streamline your workflow, not get stuck in a cycle of copy and paste. Fortunately, there’s a smarter way to handle formulas in your spreadsheets. By using a combination of dynamic references and simple tricks, you can efficiently adjust your formulas to increment table values seamlessly.
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]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- is there a way to modify formulas based on inputs?let's say i want to sum 4 rows in one column. so i'd type something like =SUM(A1:D1) but what if i want to suddenly sum 10 rows? i'd have to go in and re-type the formula to =SUM(A1:J1) or drag that box to sum more rows. i'm wondering if there's a way i could type in a number in a cell, and a formula could use that to determine how many rows to select. submitted by /u/badabingbadaboomie [link] [comments]
- Dragging a formula vertically and horizontally related to a table verticallyHello, I have a table where I want to drag a conditional formula vertically, but also horizontally. I have a list of properties, and depending on whether they are residential or not, I want to distribute the quarterly expenses. I have no problem with it automatically dragging down. I have it inside a table, and as soon as I put the formula in the first cell, it does it automatically. The problem arises when I want to move it to the right to calculate the following quarters. Since it's related to the table where I put the total expenses, it moves from column C to D, and I don't want that to happen. I want it to move horizontally from C3 to C4, down one row. Any ideas? I've tried using the transpose function, but it causes an overflow for all the properties at once. Screenshot attached. Translated from Spanish using Google Translate -.-'' https://preview.redd.it/jkmq71ftwuig1.png?width=2222&format=png&auto=webp&s=7479111ae6ce698e8d5e7d152b6281fdf60a050e submitted by /u/EstefaniaExcel [link] [comments]