Adding numbers

  • Hello,

    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.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!