League spreadsheet

[sstephen]

Hi a friend need help with his darts league spreadsheet that is beyond my capabilities

There are 10 that have play every week for 18 weeks. There are 6 legs in each match each team are awarded the nmber of legs won

Week 1 Fixtures
White Rose	4	v	2	Fox & Hounds, Witton
Rose & Crown A	5	v	1	Streethead
Kings Arms	2	v	4	Fox & Hounds, Burton
George Inn	0	v	6	Rose & Crown B
Wheatsheaf	1	v	5	Foresters
Week 2 Fixtures
Fox & Hounds, Witton	3	v	3	Rose & Crown A
White Rose	3	v	3	Wheatsheaf
Fox & Hounds, Burton	2	v	4	Streethead
Rose & Crown B	4	v	2	Kings Arms
Foresters	4	v	2	George Inn

<colgroup><col width="151" style="width: 113pt; mso-width-source: userset; mso-width-alt: 5522;"> <col width="33" style="width: 25pt; mso-width-source: userset; mso-width-alt: 1206;"> <col width="19" style="width: 14pt; mso-width-source: userset; mso-width-alt: 694;"> <col width="33" style="width: 25pt; mso-width-source: userset; mso-width-alt: 1206;"> <col width="151" style="width: 113pt; mso-width-source: userset; mso-width-alt: 5522;"> <tbody> </tbody>

I have populated the league table manually based on the scored above but want it t do it automatically when scores are entered.

Position	Team	P	W	L	D	Pts
1	Rose & Crown B	2	1	0	0	10
2	Foresters	2	1	0	0	9
3	Rose & Crown A	2	1	0	0	8
4	White Rose	2	1	0	1	7
5	Fox & Hounds, Burton	2	0	1	0	6
6	Streethead	2	0	0	0	5
7	Fox & Hounds, Witton	2	0	0	1	5
8	Wheatsheaf	2	0	1	0	4
9	Kings Arms	2	0	1	0	4
10	George Inn	2	0	1	0	2

<colgroup><col width="64" style="width: 48pt;"> <col width="128" style="width: 96pt; mso-width-source: userset; mso-width-alt: 4681;"> <col width="64" style="width: 48pt;" span="5"> <tbody> </tbody>

 

[Rijnsent]

Hi Stephen,
as a starter, I put your data in A1:E13. Next, I added a formula in column F to see if the home team or the away team won: F2 =IF(B2>D2,1,IF(B2=D2,2,3))
Next, I made a list of all the teams, the first team in I2.
The number of points per team is basically adding up 2 SUMIFs: J2 =SUMIF(A2:A13,I2,B2:B13)+SUMIF(E2:E13,I2,D2:D13)
The number of wins is using the calculation in column F: K2 =COUNTIFS(A2:A13,I2,F2:F13,1)+COUNTIFS(E2:E13,I2,F2:F13,3)
Hope that helps,
Koen