Automatic adding and subtracting

  • Thread starter Thread starter Darlene
  • Start date Start date
D

Darlene

Hi I want to set up a chart that automatically adds and subtracts as
type in my numbers for example I am setting up a postage meter char
and everytime I add 1000 I want it to add that to the sum as I go alon
when I subtract I want it to subtract from the total etc. Hopefull
this can be done. Thanks for any help
 
Darlene

Not sure what you mean here.

Do you want this to take place in one cell like an accumulator cell?

Are your numbers entered into a column one below another where they could be
Summed in another cell?

What do you mean by "chart"?

Gord Dibben Excel MVP
 
Gord, Hello, sorry I had a feeling I was not being clear,

basically what I am doing is I order postage for our postage machine a
work and to keep track I made a "Chart"
for example it goes something like this:

A colum for date a column for postage in one for postage out then
one for running total.

Date Postage out Postage in Total

3/7
3000.00
3/8 1000.00
2000.00
3/9 2000.00
0
3/10 3000.00
3000.00

so I was wondering if I could make the cells calculate automaticall
instead of me doing it myself. I hope thats more clear. Thanks fo
your hel
 
Darlene,

Suppose :
You have the heading in row 1.

A1 : Date
B1 : Postage out
C1 : Postage in
D1 : Total

So : your dates are in column A
7 march in A2
8 march in A3
etc.

Postage out in column B
0 in B2 ( 7 march)
1000 in B3 (8 march)
etc.

Postage in in column C
0 in C2 (7 march)
0 in C3 (8 march)
etc

Total in column D
3000 in D2 ( = start total; 7 march)

then in D3 put the formula :
=D2-B3+C3
copy this formula down to D4, D5 etc.

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
 
Darlene

Because I am a nut for tracking I would add a fith column.

Column A....date
Column B....Postage out
Column C....Postage in
Column D....Daily in/out diff
Column E....Total

In D2 enter =IF(C2-B2=0,"",C2-B2) then drag/copy down column D a bunch.

In E2 enter =D2

In E3 enter =IF(D3="","",E2+D3) then drag/copy down column E a bunch.

Gord Dibben Excel MVP
 
Thanks alot Gord and A.W.J! I really appreciate the help, got lots o
new things dumped on me at work and am trying to get as organized as
possibly can
 
Back
Top