# Counting data from columns

#### rbpd5015

##### New Member
I am currently working on sports betting spreadsheet.

The part I am struggling with at this time is trying to keep track of my wins.

To make this clear a bet mlb baseball series. So each series has a unique series number starting at 1. Each series contains between 1 and 3 games.

So game one of det at tam would be series 1 game 1.

Where I am now is trying to record my series wins and losses.

A series win is any series where column L = "win".

A series loss is a series that goes winless.

A series does not count as a loss until game 1 2 and 3 are all losses. If a series has a loss for game 1 and a loss for game 2 and game 3 is blank, the series is not a loss and is waiting for the game 3 result to be posted.

The columns are as follows
C- series num
D- game num
E- bet team
F- home or away. This data is a list either "at" or "vs". This is needed so I can sort wins and losses for home and road series w/l's
G- vs team
L- "win" or "loss"

I want to put the data in the following location.
C3 - total wins
D3 - total loses
F3 - home wins
G3 - home losses

Any help would be greatly appreciated.

Matt

### Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
C_m

I would love to post it but stuck in a car till 4 am est with only the crackberry. It is on another excel forum.com . (Mods please don't boot me for saying that) with a similar title. I promise to use that link in the future.

I would really appreciated if you can help out.
Matt

Excel Workbook
ABCDEFGHIJKLMNOP
4
5DateBet UnitSeries #Game #Bet TeamH/AVS TeamLineRiskTo WinBankrollProfitW/LScore
64/1/2009111SEAATCHC-1751.751.003001.001.00Win 1
74/1/2009121BALVSCIN-1541.541.002999.46-0.54Loss 1
84/1/2009131CHCATFLA-1751.751.002997.71-2.29Loss 1
94/2/2009122BALVSCIN-1655.843.542991.87-8.13Loss23.54
104/2/2009132CHCATFLA-1445.403.752986.47-13.53Loss33.75
114/3/2009123BALVSCIN-12012.4610.382996.85-3.15Win410.381
124/3/2009133CHCATFLA-15015.2310.153007.007.00Win510.15
134/4/2009141WASVSCIN1250.801.003006.206.20Loss 1
144/4/2009151ANAATCOL-1441.441.003007.207.20Win 1
154/5/2009161BOSATCLE-1801.801.003005.405.40Loss 1
164/6/2009142WASVSCIN1152.432.803002.972.97Loss
174/6/2009162BOSATCLE-1656.273.803006.776.77Win
184/6/2009143WASVSCIN1105.676.233001.101.10Loss
19
20
Series

Does anybody know how to make this work, I have tried to count the wins but have been unable to count the losses.

Matt

Replies
0
Views
282
Replies
8
Views
552
Replies
2
Views
202
Replies
3
Views
541
Replies
6
Views
163

1,202,967
Messages
6,052,850
Members
444,603
Latest member
dustinjmangum

### 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.

### Which adblocker are you using?

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

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