I use Excel from Office 2000. I need to subtract, in a column, figures from a set amount showing the reduced total at the bottom after every deduction. How do I do that? Thanx in advance. When was the last time you did something for the first time?

I'm not quite sure what you are trying to do. Please explain your question in a little more detail, perhaps including some examples of inputs and outputs.

Hi DerbyDad03 thanx for replying. Yes I suspected that I was a little vague. This is my scenario. Amount available XXX

Electricity XX

Groceries XX

Entertainment XXBALANCE XXX

With every XX I want the balance to show the reduced amount available. I.o.w the balance should automatically reduce when I punch in the amount to be deducted.

It is just the opposite of the AUTOSUM key in Excell. In stead of adding up I want to reduce... I hope I'm a little more clear.

When was the last time you did something for the first time?

Assume: B1 = XXX for Amount available

B2 = XX for Electricity

B3 = XX for Groceries

B4 = XX for EntertainmentIn B5 (Balance) use =B1-SUM(B2:B4)

From your example I take it that the Balance amount is in cell B6. Enter this formula:

=B1-SUM(B2:B4)

MIKE

Thank you guys. I will sit down and work it out and I will keep you posted. Dave When was the last time you did something for the first time?

DerbyDad and Mike. Thanks I got it right the second time. It makes my life a little easier. Highly appreciated. Dawie When was the last time you did something for the first time?

Ask Your Question

Weekly Poll

Would you ride in a self-driving car from Tesla?

Discuss in The Lounge

Poll History