Dragging a formula vertically and horizontally related to a table vertically
Hello,
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 -.-''
[link] [comments]
Want to read more?
Check out the full article on the original site