Hello,

I hope I am posting this in the correct forum. I have an Excel problem that, I'm sure, is quite simple for anyone in this forum, but for some reason, I am not sure of how to do this. Here is what is on the attached sheet:

Column A2:A6 - list of accounts we need to keep track of the funds.

Column B2:B6 - The amount that is in each account. This amount will not be touched, so they will be locked cells.

C1 is the sum of B2:B6.

Now, here is my problem. I want to be able to input a dollar amount into Cells C2:C5 (next to their respective accounts), adding them to cells B2:B5, and at the same time adding them to the Grand total. Is there a formula to do this? Or maybe you have another way of doing it.

For example, if I input $45 to cell C2, I want that to be added to B2, and also to C1. This way either a negative or positive number will affect the sums.