I can somewhat understand that. But, that was not entirely true. He posted this so I can get more input. I also restated the question, though it was tough to explain, so that anyone else could help. I am looking for a solution to a problem, not a problem to a solution. So I will re-ask the question again. I am trying to get the cell B1 to display my current balance from the "balance" column. The formula that I am using in the "balance" column is as follows... =IF(AND(ISBLANK(E4),ISBLANK(D4)),"",F3-E4+D4). So, as an example from my post with my picture attached, I would want cell B1 to display what is being shown in cell F5. But, if I make a deposit or withdrawal in either cell D6 or E6, which would cause the cell F6 to show the new balance, I want the cell B1 to automatically update to the new balance (or automatically go from F5 to F6). I see What kyle_engineer did. But I don't want the numbers to show unless there is a deposit or withdrawal.