Summing values based on variables

I am trying to get excel keep track and total my football bets.
there are 5 different types of bets,and 3 differant results(w,l,p)

a b c d
1 TYPE OF PLAY WINNER LOSSER LOSSER/LOSSER
2 S 1 -1.1
3 P 2.33 -1
4 T 1 -1.2
5 3T 1 -1.4
6 R 4 -1.2 -1.1
7 day DATE PLAY AMOUNT TYPE RESULT TOTAL
8


this is the how i have it set up for now
any help would be great