Spreadsheet: 47025d1245939124-how-to-countif-cell-february-2009-betsexample
Sheet: Sheet1

Bet | Date | Name | Sport | Odds | Stake | Result | Return | Profit | Yield |  | Month | Bets (1) | Odds (Average) (2) | Wins (3) | Losses | Voided | Staked (4) | Return | Profit | Yield
1 | 2009-02-15 00:00:00 | A | Football | 3.25 | 20 | win |  |  |  |  | Feb 2009
2 | 2009-02-15 00:00:00 | B | Football | 4.15 | 20 | lose |  |  |  |  | Mar 2009
3 | 2009-02-16 00:00:00 | C | Tennis | 1.75 | 20 | lose |  |  |  |  | Apr 2009
4 | 2009-02-17 00:00:00 | A | Football | 3.2 | 20.3 | lose |  |  |  |  | May 2009
5 | 2009-02-17 00:00:00 | A | Ice hockey | 1.75 | 20 | lose |  |  |  |  | June 2009
6 | 2009-02-17 00:00:00 | A | Tennis | 1.9 | 20 | win |  |  |  |  | July 2009
7 | 2009-02-17 00:00:00 | A | Ice hockey | 2.25 | 20 | win |  |  |  |  | Aug 2009
8 | 2009-02-17 00:00:00 | A | Ice hockey / Denmark | 2.3 | 19.6 | lose |  |  |  |  | Sept 2009
9 | 2009-02-17 00:00:00 | A | Soccer | 2.1 | 20 | win |  |  |  |  | Oct 2009
10 | 2009-02-18 00:00:00 | B | Soccer | 2.9 | 20 | win |  |  |  |  | Nov 2009
11 | 2009-02-18 00:00:00 | A | Tennis | 2.89 | 20 | win |  |  |  |  | Dec 2009
12 | 2009-02-18 00:00:00 | A | Soccer | 1.8 | 20 | lose |  |  |  |  | Jan 2010
13 | 2009-02-18 00:00:00 | C | Soccer | 2.1 | 20 | win |  |  |  |  | Feb 2010
14 | 2009-02-18 00:00:00 | B | Tennis | 2.13 | 20 | win |  |  |  |  | Mar 2010
15 | 2009-02-19 00:00:00 | C | Soccer / International | 3.15 | 20 | lose |  |  |  |  | Apr 2010
16 | 2009-02-19 00:00:00 | B | Soccer / International | 3.25 | 20 | win |  |  |  |  | May 2010
17 | 2009-02-19 00:00:00 | B | Soccer / Other | 1.7 | 20 | win |  |  |  |  | June 2010
18 | 2009-02-20 00:00:00 | C | Soccer / Holland | 1.95 | 20 | win
19 | 2009-02-20 00:00:00 | C | Ice hockey / Slovakia | 1.75 | 20.02 | win
20 | 2009-02-19 00:00:00 | B | Soccer / England | 2.5 | 20 | lose |  |  |  |  | 1) I would like to total the number of bets made in, say February 2009. Not sure how to create a
21 | 2009-02-21 00:00:00 | B | Tennis / WTA | 2.35 | 20 | lose |  |  |  |  | formula asking, IF 'Cells in Row B = February 2009, then Count and Add to Total'
22 | 2009-02-19 00:00:00 | B | Soccer / Belgium | 3.8 | 20 | lose |  |  |  |  | 2) In the Odds Average colums I want to find out the average odds for each month, so this formula
23 | 2009-02-19 00:00:00 | A | Soccer / Turkey | 2.2 | 20 | lose |  |  |  |  | needs to total up all odds made in February 2009 and then calculate the average
24 | 2009-02-20 00:00:00 | B | Soccer / Croatia | 1.7 | 20 | win |  |  |  |  | 3) The 'Wins' column needs to be able to count the number of rows which contain a bet made in
25 | 2009-02-22 00:00:00 | B | Soccer / Germany | 1.8 | 20 | win |  |  |  |  | February 2009 and which were also a Win
26 | 2009-02-22 00:00:00 | A | Soccer / Greece | 1.9 | 20 | win |  |  |  |  | 4) I believe the Stake column would need a slightly different formula aslo as it has to total the
27 | 2009-02-22 00:00:00 | A | Soccer / Scotland | 2.05 | 14 | win |  |  |  |  | values in column F which fall in February 2009.
28 | 2009-02-19 00:00:00 | C | Soccer / Greece | 2.25 | 20 | win
29 | 2009-02-23 00:00:00 | B | Tennis / ATP | 1.88 | 20 | win |  |  |  |  | All other columns I imagine should be able to be copied and pasted from the previous examples.  If anyone
30 | 2009-02-23 00:00:00 | B | Tennis / WTA | 2.05 | 20 | lose |  |  |  |  | can point me in the right direction it would be greatly appreciated.
31 | 2009-02-23 00:00:00 | A | Soccer / England | 2.3 | 19.95 | win
32 | 2009-02-25 00:00:00 | B | Ice hockey / Finland | 1.75 | 20 | lose
33 | 2009-02-25 00:00:00 | A | Handball / Austria | 1.67 | 20.3 | lose
34 | 2009-02-27 00:00:00 | A | Soccer / Scotland | 1.9 | 20 | win
35 | 2009-03-02 00:00:00 | C | Ice hockey / Czech Republic | 1.9 | 20 | win
36 | 2009-03-03 00:00:00 | B | Soccer / England | 2.15 | 20 | win
37 | 2009-03-03 00:00:00 | C | Soccer / Scotland | 3.3 | 20 | win
38 | 2009-03-03 00:00:00 | B | Soccer / Austria | 2.2 | 20 | lose
39 | 2009-03-03 00:00:00 | B | League: Soccer / France | 2.55 | 20 | win
40 | 2009-03-04 00:00:00 | A | League: Soccer / Switzerland | 1.9 | 20 | win
41 | 2009-03-04 00:00:00 | B | Soccer / England | 2.7 | 20 | lose
42 | 2009-03-04 00:00:00 | C | Soccer / International | 2 | 20 | win
43 | 2009-03-05 00:00:00 | A | Ice hockey / Finland | 2.6 | 20 | win
44 | 2009-03-05 00:00:00 | A | Soccer / Holland | 2.25 | 20 | lose
45 | 2009-03-06 00:00:00 | A | Soccer / Holland | 1.7 | 20 | win
46 | 2009-03-06 00:00:00 | A | Soccer / Ireland | 3.1 | 20 | lose
47 | 2009-03-05 00:00:00 | A | Soccer / Spain | 1.7 | 20 | lose
48 | 2009-03-08 00:00:00 | A | Soccer / Slovakia | 2.1 | 20 | win
49 | 2009-03-08 00:00:00 | B | Soccer / Belgium | 2.2 | 20 | lose
50 | 2009-03-08 00:00:00 | B | Soccer / Switzerland | 1.85 | 20 | win
51 | 2009-03-08 00:00:00 | A | Soccer / Czech Republic | 3.35 | 20 | lose
52 | 2009-03-08 00:00:00 | A | Soccer / Colombia | 2.25 | 20 | win
53 | 2009-03-08 00:00:00 | C | League: Tennis / WTA | 1.85 | 20 | lose
54 | 2009-03-09 00:00:00 | B | Soccer / International | 2.05 | 20 | win
55 | 2009-03-09 00:00:00 | C | Ice hockey / Finland | 1.75 | 20 | win
56 | 2009-03-09 00:00:00 | B | Soccer / Turkey | 2.2 | 20 | win
57 | 2009-03-09 00:00:00 | B | Soccer / England | 1.75 | 20 | win
58 | 2009-03-10 00:00:00 | A | Soccer / Austria | 1.75 | 20 | lose
59 | 2009-03-10 00:00:00 | B | Soccer / England | 3.6 | 20 | win
60 | 2009-03-10 00:00:00 | C | Soccer / Austria | 2.52 | 20.3 | lose
61 | 2009-03-10 00:00:00 | A | Soccer / Finland | 2.1 | 20 | win
62 | 2009-03-11 00:00:00 | A | Soccer / Finland | 1.9 | 20 | win
63 | 2009-03-11 00:00:00 | A | Handball / Denmark | 3.35 | 21 | lose
64 | 2009-03-11 00:00:00 | B | Soccer / International | 2.3 | 20 | lose
65 | 2009-03-12 00:00:00 | A | Soccer / International | 3.3 | 20 | lose
66 | 2009-03-13 00:00:00 | A | Soccer / Singapore | 2.05 | 5.502 | lose
67 | 2009-03-13 00:00:00 | C | Soccer / France | 2.25 | 20 | win
68 | 2009-03-10 00:00:00 | B | Soccer / Scotland | 2.2 | 20 | win
69 | 2009-03-13 00:00:00 | C | Soccer / Scotland | 2.15 | 20 | win
70 | 2009-03-13 00:00:00 | B | Soccer / Scotland | 1.85 | 20 | win
71 | 2009-03-10 00:00:00 | B | Socccer / Norway | 1.85 | 20 | lose
72 | 2009-03-13 00:00:00 | A | Soccer / Belgium | 1.8 | 20.3 | win
73 | 2009-03-11 00:00:00 | B | Soccer / Germany | 1.75 | 20 | lose
74 | 2009-03-10 00:00:00 | A | Soccer / Poland | 2.3 | 20 | lose
75 | 2009-03-15 00:00:00 | A | Soccer / Croatia | 2.05 | 20 | lose
76 | 2009-03-15 00:00:00 | C | Handball / Denmark | 3.65 | 20 | win
77 | 2009-03-11 00:00:00 | B | Soccer / Czech Republic | 2.1 | 20 | lose
78 | 2009-03-15 00:00:00 | C | Soccer / France | 3 | 20 | lose
79 | 2009-03-15 00:00:00 | B | Soccer / Norway | 2.25 | 20 | lose
80 | 2009-03-09 00:00:00 | B | Soccer / Norway | 1.95 | 20 | lose
81 | 2009-03-15 00:00:00 | A | Soccer / England | 2.1 | 20 | win
82 | 2009-03-16 00:00:00 | B | Soccer / Portugal | 2.25 | 29.4 | lose
83 | 2009-03-17 00:00:00 | C | Soccer / International | 3.65 | 30 | win
84 | 2009-03-17 00:00:00 | A | Soccer / Finland | 2.4 | 30 | lose
85 | 2009-03-17 00:00:00 | A | Soccer / Austria | 3.25 | 30 | lose
86 | 2009-03-17 00:00:00 | A | Tennis / WTA | 3.25 | 29.4 | lose
87 | 2009-03-16 00:00:00 | A | Soccer / International | 1.75 | 30 | win
88 | 2009-03-18 00:00:00 | A | Soccer / Bulgaria | 1.7 | 30 | lose
89 | 2009-03-18 00:00:00 | B | Soccer / Cyprus | 2.5 | 30 | lose
90 | 2009-03-18 00:00:00 | A | Handball / Norway | 1.9 | 30 | win
91 | 2009-03-20 00:00:00 | A | Soccer / Germany | 3.65 | 30 | lose
92 | 2009-03-20 00:00:00 | C | Soccer / Austria | 3.25 | 30 | lose
93 | 2009-03-20 00:00:00 | B | Soccer / Austria | 2.1 | 30 | win
94 | 2009-03-20 00:00:00 | C | Soccer / France | 2.85 | 30 | win
95 | 2009-03-20 00:00:00 | B | Soccer / Holland | 2.95 | 30 | lose
96 | 2009-03-18 00:00:00 | B | Soccer / England | 1.9 | 30 | win
97 | 2009-03-20 00:00:00 | A | Soccer / Italy | 2.85 | 30 | lose
98 | 2009-03-21 00:00:00 | B | Soccer / Scotland | 2.2 | 30 | lose
99 | 2009-03-21 00:00:00 | C | Soccer / England | 2.45 | 30 | win
100 | 2009-03-21 00:00:00 | A | Soccer / Scotland | 2.35 | 30 | lose
101 | 2009-03-21 00:00:00 | A | Soccer / England | 2.2 | 30 | win
102 | 2009-03-21 00:00:00 | B | Soccer / England | 2 | 30 | win
103 | 2009-03-21 00:00:00 | A | Soccer / Scotland | 3.55 | 30 | lose
104 | 2009-03-22 00:00:00 | A | Soccer / Turkey | 3.1 | 30 | lose
105 | 2009-03-22 00:00:00 | C | Soccer / Italy | 3.4 | 30 | lose
106 | 2009-03-22 00:00:00 | B | Soccer / Czech Republic | 2.3 | 30 | lose
107 | 2009-03-22 00:00:00 | C | Soccer / Greece | 3 | 30 | lose
108 | 2009-03-22 00:00:00 | B | Soccer / Hungary | 2.2 | 30 | win
109 | 2009-03-22 00:00:00 | B | Soccer / Denmark | 3.25 | 30 | lose
110 | 2009-03-22 00:00:00 | A | Soccer / Austria | 2.6 | 30 | lose
111 | 2009-03-22 00:00:00 | B | Tennis / ATP | 1.67 | 30.8 | win
112 | 2009-03-24 00:00:00 | C | Ice hockey / Austria | 2.05 | 30 | win
113 | 2009-03-24 00:00:00 | A | Soccer / International | 2.25 | 30 | lose
114 | 2009-03-26 00:00:00 | A | Soccer / England | 2.25 | 30 | win
115 | 2009-03-27 00:00:00 | A | Soccer / England | 2.15 | 30 | lose
116 | 2009-03-27 00:00:00 | A | Soccer / England | 2.05 | 30 | win
117 | 2009-03-27 00:00:00 | A | Soccer / England | 1.75 | 30 | win
118 | 2009-03-27 00:00:00 | A | Soccer / Turkey | 3 | 30 | lose
119 | 2009-03-27 00:00:00 | C | Basketball / USA | 1.9 | 30 | win
120 | 2009-03-27 00:00:00 | B | Soccer / France | 2.95 | 23.72 | lose
121 | 2009-03-27 00:00:00 | C | Soccer / Switzerland | 1.9 | 30.14 | lose
122 | 2009-03-27 00:00:00 | B | Soccer / USA | 2.15 | 30 | win
123 | 2009-03-29 00:00:00 | B | Soccer / Wales | 2.25 | 30 | lose
124 | 2009-03-29 00:00:00 | A | Ice hockey / Austria | 1.8 | 30 | lose
125 | 2009-03-30 00:00:00 | B | Soccer / England | 2.5 | 30 | lose
126 | 2009-03-30 00:00:00 | C | Soccer / International | 2.3 | 30 | lose
127 | 2009-03-31 00:00:00 | A | Tennis / ATP | 3.05 | 30.1 | win
128 | 2009-03-31 00:00:00 | A | Soccer / England | 2.15 | 30 | win
129 | 2009-03-31 00:00:00 | B | Tennis / WTA | 3 | 30.1 | lose
130 | 2009-03-31 00:00:00 | A | Soccer / International | 2.4 | 30 | win
131 | 2009-03-31 00:00:00 | A | Soccer / Wales | 3 | 30.1 | win
132 | 2009-03-31 00:00:00 | C | Soccer / England | 2 | 30 | lose
133 | 2009-03-31 00:00:00 | A | Basketball / USA | 2.17 | 30 | lose
134 | 2009-03-31 00:00:00 | C | Basketball / Sweden | 1.75 | 13.31 | lose
135 | 2009-04-01 00:00:00 | B | Soccer / Belgium | 2.1 | 30 | win
136 | 2009-04-01 00:00:00 | C | Soccer / International | 4.55 | 30.1 | lose
137 | 2009-04-01 00:00:00 | B | Soccer / International | 2.2 | 30.1 | lose
138 | 2009-04-02 00:00:00 | B | Soccer / France | 2.2 | 30 | win
139 | 2009-04-02 00:00:00 | A | Soccer / Holland | 1.85 | 30 | win
140 | 2009-04-02 00:00:00 | A | Soccer / Holland | 2 | 30 | lose
141 | 2009-04-03 00:00:00 | C | Soccer / Holland | 1.8 | 30 | win
142 | 2009-04-03 00:00:00 | B | Soccer / Switzerland | 1.7 | 30 | win
143 | 2009-04-03 00:00:00 | C | Soccer / Portugal | 4.05 | 30 | lose
144 | 2009-04-02 00:00:00 | B | Soccer / Austria | 1.95 | 30 | win
145 | 2009-04-02 00:00:00 | B | Soccer / Austria | 2.25 | 30 | lose
146 | 2009-04-03 00:00:00 | A | Soccer / Spain | 2.5 | 30 | win
147 | 2009-04-04 00:00:00 | B | Soccer / Italy | 2.4 | 30 | win
148 | 2009-04-04 00:00:00 | C | Soccer / Czech Republic | 2.8 | 30 | lose
149 | 2009-04-04 00:00:00 | A | Soccer / Mexico | 1.9 | 30 | win
150 | 2009-04-05 00:00:00 | C | Soccer / England | 4.45 | 30 | lose
151 | 2009-04-05 00:00:00 | B | Soccer / France | 1.65 | 30 | win
152 | 2009-04-05 00:00:00 | C | Soccer / Spain | 5.65 | 30 | win
153 | 2009-04-05 00:00:00 | A | Soccer / Czech Republic | 2.15 | 30 | win
154 | 2009-04-05 00:00:00 | C | Soccer / USA | 2.25 | 30.4 | win
155 | 2009-04-05 00:00:00 | B | Soccer / Chile | 1.95 | 30 | win
156 | 2009-04-05 00:00:00 | C | Soccer / Brazil | 2.45 | 30 | lose
157 | 2009-04-06 00:00:00 | B | Tennis / WTA | 1.6 | 30.2 | win
158 | 2009-04-07 00:00:00 | B | Soccer / Germany | 2.4 | 30 | win
159 | 2009-04-07 00:00:00 | A | Tennis / ATP | 1.75 | 25 | win
160 | 2009-04-06 00:00:00 | B | Soccer / England | 2.5 | 30 | lose
161 | 2009-04-07 00:00:00 | C | Soccer / Greece | 1.9 | 30 | win
162 | 2009-04-08 00:00:00 | A | Soccer / Russia | 1.7 | 30 | lose
163 | 2009-04-08 00:00:00 | A | Tennis / ATP | 2.2 | 30 | lose
164 | 2009-04-08 00:00:00 | B | Soccer / Slovakia | 2.3 | 30 | win
165 | 2009-04-06 00:00:00 | A | Soccer / Switzerland | 2 | 30.2 | win
166 | 2009-04-07 00:00:00 | A | Soccer / England | 3.2 | 30 | win
167 | 2009-04-08 00:00:00 | C | Soccer / Denmark | 2.2 | 30.2 | win
168 | 2009-04-08 00:00:00 | B | Soccer / England | 2.25 | 30.2 | lose
169 | 2009-04-08 00:00:00 | C | Soccer / Romania | 2.35 | 22.62 | lose
170 | 2009-04-09 00:00:00 | B | Soccer / Italy | 2.4 | 30 | lose