Formula Help Please

P

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
 
J

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
 
P

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.
 
J

jan

Peter,

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

Jan
 
Top