I’m trying to figure out how to isolate a single row for a formula, ThisRow is not working as expected. Perhaps I am going about this the wrong way, any help would be appreciated.
Here is a sample doc (see row isolation for formula page). The main formula is in “Monthly Income - Gross”, as all the other use that.
How can I make it so the user can change price, amount of clients and add new packages to “Scenario Control Panel - Clients” and have the top calculations reflect correctly?
How do I make the calculation only run across a single row vs the entire column? Ie multiply price by client total and then SUM each total.