Hey, little new and in need of some help ... here we go... I know the forumula, I just dont know it in terms of Excel
Forumula: If C4:C21=NCAA then Average all cells in Colum H that are associated with NCAA in Colum C... a little complex perhaps, but all I want is an average score of away teams but associated with the correct sporting event... btw all wagering is theoretical, I'm using this to see if I could actually make some profit off of legal offshore spots gambling
hope this is clear enough,
thanks
-Byrd
Forumula: If C4:C21=NCAA then Average all cells in Colum H that are associated with NCAA in Colum C... a little complex perhaps, but all I want is an average score of away teams but associated with the correct sporting event... btw all wagering is theoretical, I'm using this to see if I could actually make some profit off of legal offshore spots gambling
hope this is clear enough,
thanks
-Byrd
SportsBook.xls | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
B | C | D | E | F | G | H | I | J | K | |||
2 | January 2004 - Sportsbook - Bowmans | |||||||||||
3 | Date | Sport | Game | Spread | W/L | Over/under | Away | Home | Winnings | Final Over/Under | ||
4 | 1/18/2004 | NFL | Indianapolis. vs New England | MoneyLine +145 | L | 43 NFL 1st/2nd Half | 14 | 24 | $ (3.45) | 38 Under | ||
5 | 1/18/2004 | NFL | Indianapolis. vs New England | Prop -110 | L | Total Ovr 20 BY IND COLTS | 14 | Void | $(11.50) | Void Prop | ||
6 | 1/18/2004 | NFL | Carolina vs. Philadelpia | PHL -4 | W | 36 NFL 1st/2nd Half | 13 | 14 | $ 9.95 | 17 Under | ||
7 | 1/19/2004 | NCAAB | Oklahoma vs. Texas Tech | MoneyLine +260 | L | 130 NCAA 1st/2nd Half | 47 | 67 | $ (5.77) | 114 Under | ||
8 | 1/19/2004 | NCAAB | Oklahoma vs. Texas Tech | Prop -110 | L | Total Ovr 10 3PT FG's MADE | 1 | 3 | $ (4.23) | Void Prop | ||
9 | 1/19/2004 | NCAAB | Colorado State vs. Utah | Prop -110 | W | Total Und 59 NCAA 1st Half | 28 | 27 | $ 10.00 | 55 Under | ||
10 | 1/19/2004 | NCAAB | Colorado State vs. Utah | Prop -110 | W | Total Und 67 NCAA 2nd Half | 21 | 40 | $ 10.00 | 61 Under | ||
11 | 1/20/2004 | NCAAB | Missouri vs. Texas | Prop -110 | W | Total Und 14 3PT FG's MADE | 111 | Void | $ (3.50) | 8 Under | ||
12 | 1/20/2004 | NBA | New Jersey vs. Dallas | DAL -5 | W | 195 NBA 1st/2nd Half | 93 | 106 | $ 10.00 | 199 Over | ||
13 | 1/20/2004 | NCAAB | Texas vs. Missouri | MoneyLine +115 | L | 154 NCAA 1st/2nd Half | 75 | 69 | $ 5.00 | 144 Under | ||
14 | 1/20/2004 | NCAAB | Texas vs. Missouri | Prop -110 | L | Total Und 77 NCAA 2nd Half | 53 | 44 | $(11.00) | 97 Over (Overtime) | ||
15 | 1/21/2004 | NCAAB | Cinncinati vs. Louisville | Prop -140 | W | Total Und 15 3PT FG's MADE | 111 | [13] | $ 9.50 | 13 Under | ||
16 | 1/22/2004 | NBA | Golden Stave vs. Seatle | SEA -8 | L | Total Ovr 201 NBA | 87 | 103 | $(11.00) | 190 Under | ||
17 | 1/22/2004 | NCAAB | UCLA vs. Stanford | Prop -110 | W | Total Und 71 NCAA 2nd Half | 31 | 26 | $ 10.00 | 56 Under | ||
18 | 1/23/2004 | NCAAB | Loyola Maryland vs. Manhattan | Manhattan -27 | L | Void None | 63 | 96 | $ 18.70 | Void None | ||
19 | 1/24/2004 | NCAAB | Duke vs. Georgetown | Void | L | 68 NCAA 1st Half | 48 | 24 | $(11.00) | 72 Over | ||
20 | 1/24/2004 | NCAAB | Oklahoma State vs. Texas | Oklahoma State +4 | L | 70 NCAA 1st Half | 32 | 35 | $ 11.00 | 67 Under | ||
21 | 1/24/2004 | NCAAB | Virginia vs. North Carolina | Virginia +9 | L | 86 NCAA 2nd Half | 37 | 54 | $(11.00) | 91 Over | ||
22 | ||||||||||||
23 | ||||||||||||
January 2004 |