Win/Loss/Draw statistic

**acedabrain** · 03-03-2011, 07:40 AM

Hi there,

Sorry for my request for help here but I assume I'm a victim of my limited knowledge.

I'm building a league table for my Darts-Club. So far I progressed quite well and all the results and their corresponding points are calculated and displayed right where they should and the macros are working well.

The only problem I have is to find a formula to display the Wins/Losses/Draws in my League table just by entering the results in the corresponding games.

I have a league table sheet and a match result sheet. The match result sheet looks like this:

Column B =Team1, Column C =Team2, Column D =Sets won(Team1), Column E = Sets won(Team2), Column F=Points for sets won(Team1), Column E=Points for sets won(Team2)

This goes on for 132 rows/games. Now I need the formula to extract the Wins/Losses/Draws for each specific team. I tried the SUMIF but I have 2 criteria here which I somehow can't implement. Then I tried the IF function and I partially succeeded but the formula got so long that it gave me the "Formula too long" error.

Basically I want the following: If a specific team plays, the outcome will automatically be detected and displayed in Cell1 for Win, or Cell2 for Loss, or Cell 3 for Draw in my league table sheet.

Actually this seems not too difficult ... but I failed

I think this has to be done with a macro.

**watersev** · 03-03-2011, 07:53 AM

hi, acedabrain, can you post sample workbook with original data and result you need to obtain?

**acedabrain** · 03-03-2011, 08:05 AM

Of course

The league table is on worksheet "Liga-Tabelle" and
the results sheet is "Liga-Ergebnisse".

The S/U/V (in english W/D/L) Colums on sheet "Liga-Tabelle" are the ones who need the code.

Thx for looking into this matter and sorry for inconvenience.

**brokenbiscuits** · 03-03-2011, 08:17 AM

You could use a couple of helper columns (see attached - cols H & I (currently hidden) on Liga-Ergebnisse tab) to keep things simple avoid the use of a macro.

**acedabrain** · 03-03-2011, 09:12 AM

Thx mate

That worked like a charm

I had the same idea with the helper columns on the Liga-Ergebnisse tab. As you still can see the 1's and 0's on the left side ... I thought I could manage something with the SUMIF till I got stuck.

Thx again

and lol ... I found it somehow depressing how fast this was solved and me taking 1 day of try and error

but now I'm more excited that it works !

Cheers!