Counting Wins from Columns

[rbpd5015]

I ahave asked this a question a few times so far with no answers. I went back and read the question and it sound like I was being to general. So I wrote a more specific explanation.

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
M- "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.

I have uploaded my latest version #5 of my spreadsheet

Matt

[rbpd5015]

I don't mean to bump, this but 0 replies??? I don't understand am I asking for something that is extremely hard to do in excel?


Matt

[NBVC]

Firstly, it would have been more thoughtful if you continued on your previous post where I asked you to better explain the question.....

See attached to see if this works for you.

I added a helper column, column O to determine series Wins/Losses... then used that column to do the counts you need.

Formula in O6: =IF(M6="Win","W",IF(D6<=3,IF(COUNTIFS($C$6:C6,C6,$M$6:M6,"Loss")=3,"L","")))

Copied down

Then,

C3: =COUNTIF($O:$O,"W")

D3: =COUNTIF($O:$O,"L")

E3: =COUNTIFS($O:$O,"W",$F:$F,"VS")

F3: =COUNTIFS($O:$O,"L",$F:$F,"VS")

G3: =COUNTIFS($O:$O,"W",$F:$F,"AT")

H3: =COUNTIFS($O:$O,"L",$F:$F,"AT")

Hope this is what you wanted.