Automatic adding and subtracting

[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

 

[Gord Dibben]

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

 

[Darlene]

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

 

[A.W.J. Ales]

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 *

 

[Gord Dibben]

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