Counting data from columns

[rbpd5015]

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
I3 - road wins
J3 - road losses


Any help would be greatly appreciated.

Matt

 

[c_m]

could you post you sheet using
http://www.excel-jeanie-html.de/index.php?f=1

 

[rbpd5015]

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

 

[rbpd5015]

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
4
5	Date	Bet Unit	Series #	Game #	Bet Team	H/A	VS Team	Line	Risk	To Win	Bankroll	Profit	W/L	Score
6	4/1/2009	1	1	1	SEA	AT	CHC	-175	1.75	1.00	3001.00	1.00	Win			1
7	4/1/2009	1	2	1	BAL	VS	CIN	-154	1.54	1.00	2999.46	-0.54	Loss			1
8	4/1/2009	1	3	1	CHC	AT	FLA	-175	1.75	1.00	2997.71	-2.29	Loss			1
9	4/2/2009	1	2	2	BAL	VS	CIN	-165	5.84	3.54	2991.87	-8.13	Loss		2	3.54
10	4/2/2009	1	3	2	CHC	AT	FLA	-144	5.40	3.75	2986.47	-13.53	Loss		3	3.75
11	4/3/2009	1	2	3	BAL	VS	CIN	-120	12.46	10.38	2996.85	-3.15	Win		4	10.381
12	4/3/2009	1	3	3	CHC	AT	FLA	-150	15.23	10.15	3007.00	7.00	Win		5	10.15
13	4/4/2009	1	4	1	WAS	VS	CIN	125	0.80	1.00	3006.20	6.20	Loss			1
14	4/4/2009	1	5	1	ANA	AT	COL	-144	1.44	1.00	3007.20	7.20	Win			1
15	4/5/2009	1	6	1	BOS	AT	CLE	-180	1.80	1.00	3005.40	5.40	Loss			1
16	4/6/2009	1	4	2	WAS	VS	CIN	115	2.43	2.80	3002.97	2.97	Loss
17	4/6/2009	1	6	2	BOS	AT	CLE	-165	6.27	3.80	3006.77	6.77	Win
18	4/6/2009	1	4	3	WAS	VS	CIN	110	5.67	6.23	3001.10	1.10	Loss
19
20
Series

 

[rbpd5015]

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

Matt