Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

Excel Question??

Mar 6, 2006 9:12PM PST

If I have a total in one cell and I make a payment in another cell and I want to subtract the payment from the total...as I go along How do i do this??? example cell a1 has 3500.00 and payments are made in cell b1-36 each week ...how do i get the 3500 cell to subtract the payment cell and then record the new total in the total cell...


Thanks in advanc

Discussion is locked

- Collapse -
=a1-sum(b1:b36)
Mar 6, 2006 10:05PM PST

Of if you didn't know the sum function:
=a1-b1-b2-b3-b4-b5-b6-b7-b8-b9-b10-b11-b12-b13-b14-b15-b16-b17-b18-b19-b20-b21-b22-b23-b24-b25-b26-b27-b28-b29-b30-b31-b32-b33-b34-b35-b36

But I think it's easier with the sum.

All of this is VERY elementary use of Excel. Don't you think it would be useful to do some study? There are lots of nice introductory books (in the bookshop and the library) and tutorials (on Internet) and you might learn quite a lot of useful things.

Kees

- Collapse -
Try...
Mar 6, 2006 10:50PM PST

Cell a1 enter3,500
cell b1 enter payment amount for first day, e.g. 150
In cell c1, enter 3,350 as the result for the first substraction.

At cell b2, enter the next day's value, and at cell c2, enter the formula =sum(c1,-b2), which returns the balance for the second day. Now, copy the formula in cell c2 to the cells below by placing the cursor at the bottom right corner until it changes to a +, then drag down..... Column c then shows the ''cumulative'' balances for each day as you enter the value for each day to column b.... You will notice that the last balance will be shown all the way down in column c. Hpowever, you can hide the unwanted values by a custom format of the cells (e.g. change the font color to white.) so that only the new balance will appear as you go along...(leave to you to figure it out !)

I hope the above works for you, and that I have described the procedure correctly. I am not an expert, and I suspect this is only one of the methods to achieve what you require.