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.
For example, if I input $45 to cell C2, I want that to be added to B2, and also to C1.