A simple addition and subtraction in columns, as follows:

Take the original balance, then add to it the first amount in one column, subtract the line amount in another column, then end up with the answer in a "running balance" column. Go to the next line, and in the ADDITION column, add it, go over to the SUBTRACTION column and subtract that amount, then go over and end up with the answer in the "running balance" column. After MANUALLY computing three or four of the lines, THEN "PULL DOWN" the long column and end up AUTOMATIcally with the individual line balances. [I USED TO KNOW HOW TO DO THIS!]

Hi, In cells A1, B1 & C1 headings: Add Subtract Running Balance

In Cell C2 the opening balance

In cells A3 and below values to add

In cells B3 and below values to subtract

In cell C3 this formula:=C2+A3-B3and just drag it down as many rows as required.A B C 1 Add Sub Balance 2 100 3 17 18 99 4 38 89 48 5 75 95 28 6 64 58 34 7 44 43 35 8 40 38 37 9 91 42 86Hope this is what you were after

Regards

Thank you for responding; HOWEVER, your suggested method is EXACTLY what I have tried --and what I was trying all along, and what I thought I had always used-- BUT

Thank you for responding; HOWEVER, your suggested method is EXACTLY what I have tried --and what I was trying all along, and what I thought I had always PREVIOUSLY used-- BUT it will not work! I have opened the cells to see if there is any "restriction" or otherwise therein, but, no luck. Any other suggestion(s)?

Thank you.

BUT it will not work!In what way does it not work?

Do you get an error message?

Are the figures incorrect? How are they incorrect?

I have opened the cells to see if there is any "restriction" or otherwiseDon't understand what you mean by this?

MIKE

Hi, Using the sample data I provided:

1. Can you post the contents of cell C9, taken from the Formula bar,

2. What does cell C9 show on your screen

3. When you say it doesn't work, what do you see. Do any of the cells in column C below the opening balance (100) show anything?Regards

Ask Your Question

Weekly Poll

When do you think most people will be driving electric cars?

Discuss in The Lounge

Poll History