A Little Help.. Sports Wagering Sheet..

Byrd

New Member
Joined
Jan 24, 2004
Messages
1
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
SportsBook.xls
BCDEFGHIJK
2January 2004 - Sportsbook - Bowmans
3DateSportGameSpreadW/LOver/underAwayHomeWinningsFinal Over/Under
41/18/2004NFLIndianapolis. vs New EnglandMoneyLine +145L43 NFL 1st/2nd Half1424$ (3.45)38 Under
51/18/2004NFLIndianapolis. vs New EnglandProp -110LTotal Ovr 20 BY IND COLTS14Void$(11.50)Void Prop
61/18/2004NFLCarolina vs. PhiladelpiaPHL -4W36 NFL 1st/2nd Half1314$ 9.9517 Under
71/19/2004NCAABOklahoma vs. Texas TechMoneyLine +260L130 NCAA 1st/2nd Half4767$ (5.77)114 Under
81/19/2004NCAABOklahoma vs. Texas TechProp -110LTotal Ovr 10 3PT FG's MADE13$ (4.23)Void Prop
91/19/2004NCAABColorado State vs. UtahProp -110WTotal Und 59 NCAA 1st Half2827$ 10.0055 Under
101/19/2004NCAABColorado State vs. UtahProp -110WTotal Und 67 NCAA 2nd Half2140$ 10.0061 Under
111/20/2004NCAABMissouri vs. TexasProp -110WTotal Und 14 3PT FG's MADE111Void$ (3.50)8 Under
121/20/2004NBANew Jersey vs. DallasDAL -5W195 NBA 1st/2nd Half93106$ 10.00199 Over
131/20/2004NCAABTexas vs. MissouriMoneyLine +115L154 NCAA 1st/2nd Half7569$ 5.00144 Under
141/20/2004NCAABTexas vs. MissouriProp -110LTotal Und 77 NCAA 2nd Half5344$(11.00)97 Over (Overtime)
151/21/2004NCAABCinncinati vs. LouisvilleProp -140WTotal Und 15 3PT FG's MADE111[13]$ 9.5013 Under
161/22/2004NBAGolden Stave vs. SeatleSEA -8LTotal Ovr 201 NBA87103$(11.00)190 Under
171/22/2004NCAABUCLA vs. StanfordProp -110WTotal Und 71 NCAA 2nd Half3126$ 10.0056 Under
181/23/2004NCAABLoyola Maryland vs. ManhattanManhattan -27LVoid None6396$ 18.70Void None
191/24/2004NCAABDuke vs. GeorgetownVoidL68 NCAA 1st Half4824$(11.00)72 Over
201/24/2004NCAABOklahoma State vs. TexasOklahoma State +4L70 NCAA 1st Half3235$ 11.0067 Under
211/24/2004NCAABVirginia vs. North CarolinaVirginia +9L86 NCAA 2nd Half3754$(11.00)91 Over
22
23
January 2004
 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

Zack Barresse

MrExcel MVP
Joined
Dec 9, 2003
Messages
10,881
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
  2. Mobile
  3. Web
i know there's better formulas, but i'm a simpleton. and i'd create each it's own seperate column with an if statement then average those columns like so:
Book1
ABCDEFGHIJK
11/18/2004NFLIndianapolis.vsNewEnglandMoneyLine+145L43NFL1st/2ndHalf1424($3.45)38Under 
21/18/2004NFLIndianapolis.vsNewEnglandProp-110LTotalOvr20BYINDCOLTS14Void($11.50)VoidProp 
31/18/2004NFLCarolinavs.PhiladelpiaPHL-4W36NFL1st/2ndHalf1314$9.9517Under 
41/19/2004NCAABOklahomavs.TexasTechMoneyLine+260L130NCAA1st/2ndHalf4767($5.77)114Under47
51/19/2004NCAABOklahomavs.TexasTechProp-110LTotalOvr103PTFG'sMADE13($4.23)VoidProp1
61/19/2004NCAABColoradoStatevs.UtahProp-110WTotalUnd59NCAA1stHalf2827$10.0055Under28
725.33
Sheet1


i know it's terribly boring and cumbersome, but it autofills quick, and is easy for the simple user (like me :wink: )

although i'm sure around here you'll find bigger, better and shinier answers
 

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,209
=AVERAGE(IF(LEFT(C4:C21,4)="NCAA",H4:H21))

which must be confirmed with control+shift+enter instead of just enter.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,152,101
Messages
5,768,100
Members
425,453
Latest member
bince

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top