# Subtracting in a column

May 5, 2009 at 02:48:41
Specs: Windows XP, Pentium 4 and 1.5gb
 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?

See More: Subtracting in a column

#1
May 5, 2009 at 07:14:26
 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.

Report •

#2
May 5, 2009 at 12:59:53
 Hi DerbyDad03 thanx for replying. Yes I suspected that I was a little vague. This is my scenario. Amount available XXXElectricity XXGroceries XXEntertainment XXBALANCE XXXWith 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?

Report •

#3
May 5, 2009 at 13:14:09
 Assume:B1 = XXX for Amount available B2 = XX for ElectricityB3 = XX for GroceriesB4 = XX for EntertainmentIn B5 (Balance) use =B1-SUM(B2:B4)

Report •

Related Solutions

#4
May 5, 2009 at 13:15:25
 From your example I take it that the Balance amount is in cell B6.Enter this formula:=B1-SUM(B2:B4)MIKEhttp://www.skeptic.com/

Report •

#5
May 5, 2009 at 13:20:15
 Thank you guys. I will sit down and work it out and I will keep you posted. DaveWhen was the last time you did something for the first time?

Report •

#6
May 5, 2009 at 13:40:33
 DerbyDad and Mike. Thanks I got it right the second time. It makes my life a little easier. Highly appreciated. DawieWhen was the last time you did something for the first time?

Report •