# Counting data from columns

#### rbpd5015

##### New Member
#1 I need to be able to count the series and tell if they win or loose so I can update my record.And I know the followingA Series Win = during a series game 1-3 where W/L = WinA Series Loss = a series 1-3 where there are no wins. A series does not count as a loss until you loose game #3.Matt

### Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.
rbpd: When I see a post that has had 20 people read it and not even one answer, I know there's usually something odd with it.

Your post is extremely cryptic. To get you started:

1. Define what your series is. Is it numeric? Is it text?
2. Define where your series is. In column A starting with row 2 and going down 100 rows?

To get you started with simple count functions, check Excel's help system for count functions. You'll find COUNT(), COUNTA(), COUNTIF() as examples.

Further, you can check the articles section of MrExcel for introductions to functions.

NBRCrunch

I will try 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

Replies
1
Views
366
Replies
10
Views
640
Replies
4
Views
387
Replies
4
Views
260
Replies
8
Views
434

1,203,061
Messages
6,053,308
Members
444,651
Latest member
markkuznetsov1

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