I would be curious what brackets you added or any other edits you tried. Keeping track of parentheses is one of my least favorite parts of algebra and programming. If the forum software will render it correctly, I use a strategy like this to try to keep track of parentheses:
It still appears to me that you have not correctly matched the parentheses. The leftmost open parenthesis (that you claim matches the rightmost close parenthesis) actually appears to match the close parenthesis immediately before the subtraction sign. The rightmost close parenthesis appears to match the opening parenthesis immediately after the subtraction sign before the second INDIRECT() function. Again, I don't know what variations you tried, but it still appears to me that the solution to your question is to get the parentheses correctly placed in the formula. Once the parentheses are correctly placed, then I would expect the formula to calculate correctly.
Bookmarks