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

Report •


#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 XXX
Electricity XX
Groceries XX
Entertainment XX

BALANCE 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?


Report •

#3
May 5, 2009 at 13:14:09
Assume:

B1 = XXX for Amount available

B2 = XX for Electricity
B3 = XX for Groceries
B4 = XX for Entertainment

In 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)

MIKE

http://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. Dave

When 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. Dawie

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


Report •


Ask Question