1.

      Simulate a fair coin toss in Excel 20 times.

a.      If you get more heads than tails, you win; and vice versa for more tails. It’s a tie if you get the same number of heads and
2.      Repeat this exercise for 200 rounds.
a.      If $10 is wagered for each round, how much have you won and lost? How much money was exchanged in total?
he same number of heads and tails.

s exchanged in total?
Money bet per round $10

Money
exchange
# Heads # Tails Win/loss Win/loss d Round Toss 1 Toss 2
Round 1
Round 2
Round 3
Round 4
Round 5
Round 6
Round 7
Round 8
Round 9
Round 10
Round 11
Round 12
Round 13
Round 14
Round 15
Round 16
Round 17
Round 18
Round 19
Round 20
Round 21
Round 22
Round 23
Round 24
Round 25
Round 26
Round 27
Round 28
Round 29
Round 30
Round 31
Round 32
Round 33
Round 34
Round 35
Round 36
Round 37
Round 38
Round 39
Round 40
Round 41
Round 42
Round 43
Round 44
Round 45
Round 46
Round 47
Round 48
Round 49
Round 50
Round 51
Round 52
Round 53
Round 54
Round 55
Round 56
Round 57
Round 58
Round 59
Round 60
Round 61
Round 62
Round 63
Round 64
Round 65
Round 66
Round 67
Round 68
Round 69
Round 70
Round 71
Round 72
Round 73
Round 74
Round 75
Round 76
Round 77
Round 78
Round 79
Round 80
Round 81
Round 82
Round 83
Round 84
Round 85
Round 86
Round 87
Round 88
Round 89
Round 90
Round 91
Round 92
Round 93
Round 94
Round 95
Round 96
Round 97
Round 98
Round 99
Round 100
Round 101
Round 102
Round 103
Round 104
Round 105
Round 106
Round 107
Round 108
Round 109
Round 110
Round 111
Round 112
Round 113
Round 114
Round 115
Round 116
Round 117
Round 118
Round 119
Round 120
Round 121
Round 122
Round 123
Round 124
Round 125
Round 126
Round 127
Round 128
Round 129
Round 130
Round 131
Round 132
Round 133
Round 134
Round 135
Round 136
Round 137
Round 138
Round 139
Round 140
Round 141
Round 142
Round 143
Round 144
Round 145
Round 146
Round 147
Round 148
Round 149
Round 150
Round 151
Round 152
Round 153
Round 154
Round 155
Round 156
Round 157
Round 158
Round 159
Round 160
Round 161
Round 162
Round 163
Round 164
Round 165
Round 166
Round 167
Round 168
Round 169
Round 170
Round 171
Round 172
Round 173
Round 174
Round 175
Round 176
Round 177
Round 178
Round 179
Round 180
Round 181
Round 182
Round 183
Round 184
Round 185
Round 186
Round 187
Round 188
Round 189
Round 190
Round 191
Round 192
Round 193
Round 194
Round 195
Round 196
Round 197
Round 198
Round 199
Round 200
Toss 3 Toss 4 Toss 5 Toss 6 Toss 7 Toss 8 Toss 9 Toss 10 Toss 11 Toss 12
Toss 13 Toss 14 Toss 15 Toss 16 Toss 17 Toss 18 Toss 19 Toss 20
Number of wins
Number of losses
Number of ties
Total rounds played

Amount of money won

Amount of money lost
Total earnings
Total money exchanged
Money bet per round $10

=IF(A6>B6 =IF(C6="
,"Win",IF( Win", =IF(RAND =IF(RAND
=COUNTI A6<B6,"L $B$1,IF(C BETWEEN BETWEEN
=COUNTIF(H6:AA6," F(H6:AA6, oss","Tie" 6="Loss",- (0,1)=0,"T (0,1)=0,"T
H") "T") )) $B$1,0)) =ABS(D6) ","H") ","H")

Money
exchange
# Heads # Tails Win/loss Win/loss d Round Toss 1 Toss 2
9 11 Loss -10 10 Round 1 H T
13 7 Win 10 10 Round 2 T T
14 6 Win 10 10 Round 3 T H
9 11 Loss -10 10 Round 4 T T
9 11 Loss -10 10 Round 5 H T
12 8 Win 10 10 Round 6 H H
11 9 Win 10 10 Round 7 T T
8 12 Loss -10 10 Round 8 T T
9 11 Loss -10 10 Round 9 H T
10 10 Tie 0 0 Round 10 H H
11 9 Win 10 10 Round 11 T T
5 15 Loss -10 10 Round 12 T T
8 12 Loss -10 10 Round 13 T T
11 9 Win 10 10 Round 14 H T
12 8 Win 10 10 Round 15 H H
14 6 Win 10 10 Round 16 T H
9 11 Loss -10 10 Round 17 H T
6 14 Loss -10 10 Round 18 T H
8 12 Loss -10 10 Round 19 H T
6 14 Loss -10 10 Round 20 T T
8 12 Loss -10 10 Round 21 T T
14 6 Win 10 10 Round 22 T T
13 7 Win 10 10 Round 23 H T
8 12 Loss -10 10 Round 24 T H
13 7 Win 10 10 Round 25 T H
9 11 Loss -10 10 Round 26 T H
7 13 Loss -10 10 Round 27 H H
8 12 Loss -10 10 Round 28 T T
11 9 Win 10 10 Round 29 H T
12 8 Win 10 10 Round 30 H H
10 10 Tie 0 0 Round 31 H T
8 12 Loss -10 10 Round 32 H H
11 9 Win 10 10 Round 33 H H
10 10 Tie 0 0 Round 34 H H
11 9 Win 10 10 Round 35 T H
11 9 Win 10 10 Round 36 H T
 8 12 Loss -10 10 Round 37 H T
11 9 Win 10 10 Round 38 T T
10 10 Tie 0 0 Round 39 H H
9 11 Loss -10 10 Round 40 H H
16 4 Win 10 10 Round 41 H H
12 8 Win 10 10 Round 42 H H
10 10 Tie 0 0 Round 43 T T
10 10 Tie 0 0 Round 44 H T
14 6 Win 10 10 Round 45 H H
7 13 Loss -10 10 Round 46 T T
7 13 Loss -10 10 Round 47 H T
11 9 Win 10 10 Round 48 H H
10 10 Tie 0 0 Round 49 T H
14 6 Win 10 10 Round 50 T H
5 15 Loss -10 10 Round 51 T H
8 12 Loss -10 10 Round 52 H T
11 9 Win 10 10 Round 53 H T
10 10 Tie 0 0 Round 54 H H
12 8 Win 10 10 Round 55 T T
10 10 Tie 0 0 Round 56 T T
12 8 Win 10 10 Round 57 H H
10 10 Tie 0 0 Round 58 H H
9 11 Loss -10 10 Round 59 T H
10 10 Tie 0 0 Round 60 T H
14 6 Win 10 10 Round 61 H H
9 11 Loss -10 10 Round 62 T T
11 9 Win 10 10 Round 63 T T
13 7 Win 10 10 Round 64 T H
11 9 Win 10 10 Round 65 H H
9 11 Loss -10 10 Round 66 T T
9 11 Loss -10 10 Round 67 H T
7 13 Loss -10 10 Round 68 H T
12 8 Win 10 10 Round 69 T T
6 14 Loss -10 10 Round 70 T T
10 10 Tie 0 0 Round 71 H T
9 11 Loss -10 10 Round 72 T H
10 10 Tie 0 0 Round 73 H T
10 10 Tie 0 0 Round 74 T H
9 11 Loss -10 10 Round 75 T T
11 9 Win 10 10 Round 76 T T
10 10 Tie 0 0 Round 77 T T
14 6 Win 10 10 Round 78 H H
14 6 Win 10 10 Round 79 H H
9 11 Loss -10 10 Round 80 H H
7 13 Loss -10 10 Round 81 T T
12 8 Win 10 10 Round 82 H T
11 9 Win 10 10 Round 83 T H
16 4 Win 10 10 Round 84 H H
11 9 Win 10 10 Round 85 H H
12 8 Win 10 10 Round 86 H T
6 14 Loss -10 10 Round 87 H T
9 11 Loss -10 10 Round 88 T H
11 9 Win 10 10 Round 89 T H
11 9 Win 10 10 Round 90 T T
10 10 Tie 0 0 Round 91 H T
11 9 Win 10 10 Round 92 H T
7 13 Loss -10 10 Round 93 T T
13 7 Win 10 10 Round 94 T H
7 13 Loss -10 10 Round 95 T H
8 12 Loss -10 10 Round 96 T H
11 9 Win 10 10 Round 97 T H
7 13 Loss -10 10 Round 98 T T
12 8 Win 10 10 Round 99 T H
7 13 Loss -10 10 Round 100 H T
11 9 Win 10 10 Round 101 H H
9 11 Loss -10 10 Round 102 T T
8 12 Loss -10 10 Round 103 H T
13 7 Win 10 10 Round 104 T H
7 13 Loss -10 10 Round 105 H H
11 9 Win 10 10 Round 106 T T
9 11 Loss -10 10 Round 107 H H
10 10 Tie 0 0 Round 108 H T
5 15 Loss -10 10 Round 109 T T
8 12 Loss -10 10 Round 110 T H
12 8 Win 10 10 Round 111 T H
8 12 Loss -10 10 Round 112 H T
10 10 Tie 0 0 Round 113 T T
12 8 Win 10 10 Round 114 T H
9 11 Loss -10 10 Round 115 H T
11 9 Win 10 10 Round 116 H H
7 13 Loss -10 10 Round 117 H T
6 14 Loss -10 10 Round 118 H H
10 10 Tie 0 0 Round 119 T H
10 10 Tie 0 0 Round 120 H H
8 12 Loss -10 10 Round 121 H T
9 11 Loss -10 10 Round 122 T H
14 6 Win 10 10 Round 123 H H
11 9 Win 10 10 Round 124 H H
12 8 Win 10 10 Round 125 H H
7 13 Loss -10 10 Round 126 T T
12 8 Win 10 10 Round 127 H H
10 10 Tie 0 0 Round 128 T H
10 10 Tie 0 0 Round 129 T T
10 10 Tie 0 0 Round 130 T T
11 9 Win 10 10 Round 131 H H
12 8 Win 10 10 Round 132 H H
16 4 Win 10 10 Round 133 H H
12 8 Win 10 10 Round 134 H H
11 9 Win 10 10 Round 135 H T
11 9 Win 10 10 Round 136 H T
7 13 Loss -10 10 Round 137 T T
11 9 Win 10 10 Round 138 H H
9 11 Loss -10 10 Round 139 H H
4 16 Loss -10 10 Round 140 T T
12 8 Win 10 10 Round 141 T T
11 9 Win 10 10 Round 142 H T
7 13 Loss -10 10 Round 143 T T
12 8 Win 10 10 Round 144 H H
10 10 Tie 0 0 Round 145 H H
10 10 Tie 0 0 Round 146 T H
13 7 Win 10 10 Round 147 H H
10 10 Tie 0 0 Round 148 H H
12 8 Win 10 10 Round 149 T T
10 10 Tie 0 0 Round 150 H T
12 8 Win 10 10 Round 151 T T
8 12 Loss -10 10 Round 152 T T
9 11 Loss -10 10 Round 153 T T
12 8 Win 10 10 Round 154 T T
7 13 Loss -10 10 Round 155 T T
10 10 Tie 0 0 Round 156 H T
7 13 Loss -10 10 Round 157 T H
10 10 Tie 0 0 Round 158 T H
10 10 Tie 0 0 Round 159 H T
8 12 Loss -10 10 Round 160 H T
14 6 Win 10 10 Round 161 T H
9 11 Loss -10 10 Round 162 T H
9 11 Loss -10 10 Round 163 H T
7 13 Loss -10 10 Round 164 T H
11 9 Win 10 10 Round 165 T H
9 11 Loss -10 10 Round 166 T H
9 11 Loss -10 10 Round 167 T T
8 12 Loss -10 10 Round 168 H T
8 12 Loss -10 10 Round 169 T H
12 8 Win 10 10 Round 170 T H
10 10 Tie 0 0 Round 171 H T
8 12 Loss -10 10 Round 172 T H
11 9 Win 10 10 Round 173 T T
9 11 Loss -10 10 Round 174 T H
8 12 Loss -10 10 Round 175 T T
7 13 Loss -10 10 Round 176 T T
9 11 Loss -10 10 Round 177 H H
 8 12 Loss -10 10 Round 178 H T
6 14 Loss -10 10 Round 179 H T
9 11 Loss -10 10 Round 180 H T
11 9 Win 10 10 Round 181 H H
9 11 Loss -10 10 Round 182 T T
10 10 Tie 0 0 Round 183 H H
11 9 Win 10 10 Round 184 T T
9 11 Loss -10 10 Round 185 T H
6 14 Loss -10 10 Round 186 T H
10 10 Tie 0 0 Round 187 H H
9 11 Loss -10 10 Round 188 H T
8 12 Loss -10 10 Round 189 T T
11 9 Win 10 10 Round 190 T H
7 13 Loss -10 10 Round 191 H H
6 14 Loss -10 10 Round 192 T T
9 11 Loss -10 10 Round 193 H H
10 10 Tie 0 0 Round 194 H T
9 11 Loss -10 10 Round 195 T T
8 12 Loss -10 10 Round 196 T T
9 11 Loss -10 10 Round 197 H H
7 13 Loss -10 10 Round 198 H T
7 13 Loss -10 10 Round 199 T T
12 8 Win 10 10 Round 200 T T
=IF(RAND =IF(RAND =IF(RAND =IF(RAND =IF(RAND =IF(RAND =IF(RAND =IF(RAND =IF(RAND =IF(RAND
BETWEEN BETWEEN BETWEEN BETWEEN BETWEEN BETWEEN BETWEEN BETWEEN BETWEEN BETWEEN
(0,1)=0,"T (0,1)=0,"T (0,1)=0,"T (0,1)=0,"T (0,1)=0,"T (0,1)=0,"T (0,1)=0,"T (0,1)=0,"T (0,1)=0,"T (0,1)=0,"T
","H") ","H") ","H") ","H") ","H") ","H") ","H") ","H") ","H") ","H")

Toss 3 Toss 4 Toss 5 Toss 6 Toss 7 Toss 8 Toss 9 Toss 10 Toss 11 Toss 12
H T H T H T H H T H
H H H H H H T H T H
T T H H H T H T H H
H T T H T H H T H H
T T T H H H T T H H
T H T H T H T H T H
H T H T H H H T H H
H T H T H T T H H T
T T T H H H T H H T
T H H T H T H H H H
H T T T H H H T H H
T T T T T T H H H T
H T T T H T T T H H
H T T H H H H T T T
T H T H H H T H H T
H T H H H H H T H T
T H T T H T T H T T
T T T T T T H T T H
T T T T H H T T T T
T T H T H T T T T H
H T T H H H H H T T
H H H H H H H H T H
T H H T H T H H H T
T T T T H T T T T T
H H H T H H T T T H
H T T H H T T H T T
T T H T T T H H T H
T T T H H H T T T T
T H T T H T H H H T
H T H T H H T H T H
H T H T H H T H H T
H T H T H T T H T T
T T T H H H H H T H
H T T H H T T H H T
T T H H H H T T H T
T H H H T T T H H T
H T H H T T T H H T
T H T T H H H H H H
T H T T H T T H H H
T T H T T T H T H H
H H H H T H H T H H
T T H H H T T H H T
H T H T H T H T H H
T T H H T H H T H H
H T H T H H H T H H
T H H T T T T T T H
T H T H T T T H H T
T T T T H T T H H T
H H T H H H T H H H
H H T H T H H H T T
T T T T T T T H H T
T T H T T T T T H T
T T T T T H H H H T
T T T T H H H H H T
H H H H H T T T H T
H H T H T H T T T T
T T H H H T T H T H
T T H H H H H T H T
T T H H H T H T T H
T T T T H H H H T H
H H H H H T T T H T
H H T H T T H H H T
H T T H H H H H T H
H T T H H T T H H T
H T H T H T T H T T
H T T T T H H T H H
T H T T H T H H H T
T T H T H T H T T H
T T T H T H H H H H
T T T H T H T T T T
H H H T T T H H T T
T T T T T T H H H H
H H T H T H H T H T
T T H H T T T T H H
T T T T T H H T H T
T T H T H H H H T T
H T H T H T H H T T
H T H H H T H T H T
T H H H H T T H H H
H T T T T H T H H T
T T T T T H T T T T
T H H H H H T H H H
H H H T T H H H T H
H H H H H H T T H H
H H T T H T T H T H
H H T T H H T H T H
T T H T T T T H H T
H T H T T H T H T H
H H T H H H H T T T
T H T T H H H H T H
H T H T H H T T H T
H H T T T T H T H H
H T H T T T T H T H
H H T H T H H T T H
T H T T H T T T T T
H H H T H T H T T T
T H H T T H T H H H
T T T T H H T H T T
T H H H H H T H H T
H T H H T T T T T H
T T H H T T H T T H
H T H T T H H H T H
H T H H T T T T T T
T H T H H H H H T T
H T T T H T T T T T
H H T H T H T T H H
T H T T T H T H H T
T T T H T T H T H H
T T T T H T T T T H
T H T T H T H H H T
H T T H H H T T H H
T H T H T T T H T H
T T T T H T H H H H
H H T T H T H H H H
T T H H H T T H H H
H T T H H H T T H H
H T T T H T T H T H
T H T T T T H T T T
H H H H T H T T T T
H T T T H T T H T H
T T H H H T T T H T
T T T H H T T H T H
T T H T H H H H H T
T H T T T H H H H T
H H H T T H H T H H
H T H T T T T H T T
H T T H T H T T T H
H H T T T T H T H T
T H T T H H T H T H
H T T H H H H H H H
T H H T T T T H H T
H H T H H H H T T T
H H H H T T T T H H
T T H T T H H H H T
T T T H T T H H H T
H H T H T T T H T T
T H T T T T H T H T
H T T H T T T H T H
T T H T T T H H T T
T T T T T T T T H H
H H H H H H T T H H
T H H H H H H H T T
T H T T T H T H T T
H H T T H T T T H T
T H H T T H H H T T
T T T T H H H T T H
H H T H T T H H H H
H T T T T T H H H H
T T H H T T H H T H
H H H T T H H T T T
H H H H H T T T T T
H T H T T H T T H H
H H H T H T H H H T
H H H H H T H T T H
T T T T H T H T T H
H H T H H T T H T H
T H T T T H T H T T
T T T H T T H T H T
T T H T H T H H T H
T H T H T H T T T H
H H T H H T H H T H
T T H H H T T T T T
T T H T H T H T H T
T H T H T T T H H T
T T H H T H H H T H
T H H H T T T T H T
H T H T T H H T H H
H T H T T T T T T H
H T H H H T T T T T
H T H T H T T T H H
H T H H H T H T T T
H T T H T T H T H T
T H T H T H T H H H
H T H T T T T T T H
H H T T T T T H H H
T T H H H T T T H T
T H T T T T T T T H
T T T T H H T T H H
H T T T T T H T T T
H H H H T T T T H H
T T H H T T H T H H
T H T H H H T H H T
T H T H T H T T H H
T H T H H H T T H H
T H H T H T T T H T
H T T H T H T T T H
H T T H H H T T H T
T T T H T H H T H T
T H T H T H T T H T
T H T H H T T T H H
T T T T H T T H H T
T T T H T T T T H H
T T T H T T T T H T
H T T T H T H H T T
H H H T T H H H T H
T H T T H T T H H H
T H T H H T T H H T
T T H T T H T T H T
T T T H T T T T T H
T H T H H H H H H T
=IF(RAND =IF(RAND =IF(RAND =IF(RAND =IF(RAND =IF(RAND =IF(RAND =IF(RAND
BETWEEN BETWEEN BETWEEN BETWEEN BETWEEN BETWEEN BETWEEN BETWEEN
(0,1)=0,"T (0,1)=0,"T (0,1)=0,"T (0,1)=0,"T (0,1)=0,"T (0,1)=0,"T (0,1)=0,"T (0,1)=0,"T
","H") ","H") ","H") ","H") ","H") ","H") ","H") ","H")

Toss 13 Toss 14 Toss 15 Toss 16 Toss 17 Toss 18 Toss 19 Toss 20

T H T H T T T T
T H H H T H T H
H H H H H T H H
T H T H T T H T
H T H T T H T T
T H T T H H H H
T H H H T H T T
H T T H T T T H
H T H T T T H T
T T T T H T T T
H T H T T H H H
T T T H T H T T
H T H T T H T H
H H H T T H T H
T T H H T H T H
T T H H H H H H
T H T T H H H H
H H T T T T T H
T H T H H H T H
T T H T H H T T
T T H T T T T H
T T H T H H H H
H H T H H H T H
H H T H H H H T
T T H H H H H H
H H T H H T T T
T T T H T T T T
H H H T T H T H
T H H H T H T H
H T H H T T T H
T T T H H T T H
T T T H H T T T
H H T T T T H T
T T H H H T T T
T H T H H H T H
H T H T H H H T
T T T H T T T H
H T H T H T H T
H T H T T T T H
H H T T T H T T
H H H T H H T H
T T H H H H H T
T H T H H H T T
T T H T T H H T
T T H H T H H H
H H H T T H T T
T H H T T T T T
T H H H H H H T
H T T T T T T T
H T H H H H H H
T T T H T T T H
H T T H H T H H
T H T H H H H H
T H T T H T T H
H T H H H H T H
H T H H T H H H
H T H T H H H T
H T T T H T T T
T T H H T T H T
H H T H T H T T
T H H H H H T H
T H T H T T H T
H T H T H H T T
H H H H H T H H
H T H H H H T T
H H T T H H T T
H T T T H H T T
H T T T T T T H
T H H H H H T H
H T H H T H T T
H H T H T T H T
H T H T H H T T
T T T H T H H T
H T T H H H T H
T H H T H H H H
H H H H H H T T
H T T H T H H H
H H H H T H H T
H T H T H H H T
T T T T H H T H
H T T H H H H H
T T T H H T T H
T T T T H H T H
H H T H H T H H
T T T T H H H H
T T H H H H T H
T T T H T T T H
T H T H T T H T
T T H H T T H H
T T H H H T H H
T H T H H H T T
H T T H H T H H
H T T T T H H T
T H H T H H H H
H H T T T T H H
T T T H T T H T
T H H T H H T T
T H H T T T H H
T H T T H H H T
T H T T H T T T
H H T T H H H T
H T H H T T T T
H T T H H T T H
H H H H H T T H
H T H T H T T T
H T H T H T H H
T H T T H T H T
H H T T T H H H
H T T T T H T H
T T H T T T T H
H H H T T H H T
T H T T H T T H
H T H H H T T H
T H T H H T T H
H H T T T T T T
T H T H H T T T
H T T T T T H T
H T T T T T H T
T H H T H H T T
T H H H T T H T
T T T H H T H T
T H T T H T H H
T H H T H H H H
T H T H H T H T
T T T H H T H T
H T H T H H T T
H H H H T T H H
H T H H H H T T
H T H H T H T H
H T T T T T T H
H H T H T T H H
H T H T T T H H
H H H H H H H H
T H H T H H H T
H H H H H H T T
H H H H H H T T
T H T H H T H T
H H T T T H H H
H T H H H T T T
T T T T H H T T
H H T T T H T H
T T T T H H T H
T H T H T H T H
H H T H T H H H
H T T T T H H T
H T H T T H H H
T H T T H H H T
H T H T T T H T
H H H T H H H H
T H T H T H T H
H H H H H H T H
H T H T T T T H
T H T H T T T T
T H T T H H H H
T T T H H T H H
H H H T T T T T
H H T T T T T H
H T H H T H H H
H T T T H T H H
T T T T T H H H
H H T H H H H T
H H T H T H T H
H T H T H T T H
H T T T T T H T
H H T T T H H T
T H H H T T T H
H T T T H H T T
H H H T T T T H
T H T T H H T T
T H H H H T H H
T T T H H T H H
T H T H H T T T
H H H H T H T T
H T T H H H T H
H H T T T T T H
T T H T H T T H
T T H H H H T H
H H T T H T T T
T T T T T H H H
T T T T T T H H
H T T T H T H H
H T H T T H T T
H T T T T H H T
H T H T H T H H
T H H T T T H H
T T T T H T T T
T T T H H T T H
T H T H H T H T
H T H T H T T H
H H H T H T H T
T H T H T T T T
T T H T H T T H
T H H H T H H T
T T T H H H H H
T T H T T H T T
T T T H T T H H
H H T T T T T T
T T H H T T T H
T H T H H H T H
H T T H H H H T
Number of wins 76 =COUNTIF($'cointoss-completed'.$C$6:$C$205,"Win")
Number of losses 90 =COUNTIF($'cointoss-completed'.$C$6:$C$205,"Loss")
Number of ties 34 =COUNTIF($'cointoss-completed'.$C$6:$C$205,"Tie")
Total rounds played 200 =SUM(B1:B3)

Amount of money won $760 =SUMIF($'cointoss-completed'.$D$6:$D$205,">0")

Amount of money lost -$900 =SUMIF($'cointoss-completed'.$D$6:$D$205,"<0")
Total earnings -$140 =B6+B7
Total money exchanged $1,660 =SUM($'cointoss-completed'.$E$6:$E$205)