Enter this in C1
=IF(C1="Win",B1,IF(C1="Loss",-B1,""))
and copy down

Enter in E1
=C1
Enter this in D2 and copy down
=E1+D2

"tsondrini" wrote:

I would like to keep a running total of $$ won and lost for a sports wagering
project I am working on. As seen below I would like to input the risk amount
in column A and the potential "to Win" amt in column B and then when I type
the result in Column C (either win or loss) the formula will put auto
populate the win or loss amount in the result column D for that individual
bet and also keep a running total in column E. Can anyone help me with a
formula for this? thanks very much.

Example:
A B C D E
$110 $100 Win $100 $100
$220 $200 Win $200 $300