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

Do you think Monopoly should update its pieces?

Discuss in The Lounge

Poll History