Formula Help Please

[Peter McCaul]

I'm doing a lotto chart for work. The initial investment is $250. If we
win or lose, I would like to key in the amount in the respective column and
have the amount column automatically update itself. The one thing I can't
figure out is how to take the previous days amount and make it part of the
formula. Any help is greatly appreciated. Thanks. I don't know if the
example chart I've put in will translate well on the upload but this is how
the chart looks. Thanks once again.



Initial Investment Win Lose Amount
250 10 240
10 250
153 353
30 323

 

[jan]

Peter,

A possibility:

Put this formula in D2 and drag D2 down as far as you wish:

=$A$2+SOM($B$2:B2)-SOM($C$2:C2)

Jan

 

[Peter McCaul]

I don't believe it's working unless I'm doing something wrong.

I get #NAME?.

I will repost this question with a little more detail. Thanks.

 

[Sandy Mann]

Depending on where you are try SUM in plase of SOM

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk

 

[jan]

Peter,

Sorry, I didn't translate the dutch formula.
Indeed, SOM should be written as SUM.

Jan