automatic scoring and compair schedules

[Jerk24]

Good moring.

I have a sheet were i keep track of a 12 team dart leauge that spans 18 Wks. i have been here before, and had a ton of help.

starting in C3:k3, and C5:K5 is were the first shooters scores. then below that it is C7:k7, and c9:k9 and all the way down to C193:K193

in each weeks score there are three games. 12+6+30 i was hoping there is a way to take each teams score (column B has the shooters team 1, 1.2, 1.3, 1.4 for order purposes) and have the scores totalled by game

	YOURS
Gm. 1
Gm. 2
Gm. 3
Total

<tbody>
</tbody>

then compare to the team they shot that week. not sure the easiest place to pull the schedule from. I have a schedule but it is not defined by week, I can place that weeks schedule in a particular set of cells,

After the compairson - i want the results moved to the standing sheet and add the win lose tie or total to what is already there. i know there is alot going on here and i am sure that i missed something.

TEAM #	Team Avg. w/o Hdcp.	High Team Average	Win	Loss	Tie Game	Total	Tie Total	PTS	HI GM	HI TRP	Team Handicap
Point Values		2		1	1	0.5
Team 2	74		21	9		8		50.00	97	259	2
Team 9	73		19	11		5		43.00	93	262	3
Team 4	66		18	12		6		42.00	97	286	9
Team 7	69		15	14	1	6		37.00	95	260	7
Team 3	74		14	14	2	6		36.00	102	266	2
Team 5	55		14	15	1	5		34.00	90	264	19
Team 11	68		14	14	2	4		34.00	96	253	8
Team 8	76		14	14	2	3		33.00	93	257
Team 6	70		13	17		4		30.00	93	253	6
Team 10	66		13	17		3		29.00	99	273	9
Team 12	77		11	18	1	6		29.00	92	255
Team 1	64		10	19	1	4		25.00	92	262	11

<tbody>
</tbody>

 

[Jerk24]

Is there a way to compare two cells, based on a table . I have the totals of each game shot now i want to match the teams who shot agaist each other, give the winner a +1 in the winner column, and the loser the +1 in the loses column.

The chart below ranges from AD1:AP4

Team 1</SPAN>

Team 2</SPAN>

Team 3</SPAN>

Team 4</SPAN>

Team 5</SPAN>

Team 6</SPAN>

Team 7</SPAN>

Team 8</SPAN>

Team 9</SPAN>

Team 10</SPAN>

Team 11</SPAN>

Team 12</SPAN>

Game 1</SPAN>

68</SPAN>

71</SPAN>

70</SPAN>

77</SPAN>

61</SPAN>

68</SPAN>

71</SPAN>

79</SPAN>

75</SPAN>

81</SPAN>

61</SPAN>

71</SPAN>

Game 2</SPAN>

62</SPAN>

72</SPAN>

72</SPAN>

85</SPAN>

55</SPAN>

70</SPAN>

70</SPAN>

76</SPAN>

65</SPAN>

77</SPAN>

70</SPAN>

82</SPAN>

Game 3</SPAN>

73</SPAN>

94</SPAN>

79</SPAN>

91</SPAN>

58</SPAN>

71</SPAN>

76</SPAN>

70</SPAN>

76</SPAN>

85</SPAN>

68</SPAN>

74</SPAN>

Total</SPAN>

203</SPAN>

237</SPAN>

221</SPAN>

253

174</SPAN>

209</SPAN>

217</SPAN>

225</SPAN>

216</SPAN>

243</SPAN>

199</SPAN>

227</SPAN>

<TBODY>
</TBODY><COLGROUP><COL><COL><COL span=3><COL><COL span=7></COLGROUP>

the next chart is the schedule that will be updated weekly. that is in AE25:AH31

1/7/2014</SPAN>
12</SPAN>	vs</SPAN>	10</SPAN>	BOARD 1</SPAN>
1</SPAN>	vs</SPAN>	7</SPAN>	BOARD 2</SPAN>
8</SPAN>	vs</SPAN>	9</SPAN>	BOARD 3</SPAN>
4</SPAN>	vs</SPAN>	2</SPAN>	BOARD 4</SPAN>
3</SPAN>	vs</SPAN>	11</SPAN>	BOARD 5</SPAN>
5</SPAN>	vs</SPAN>	6</SPAN>	BOARD 6</SPAN>

<TBODY>
</TBODY><COLGROUP><COL><COL span=3></COLGROUP>

The date cell is merged to fit across the whole table.

please let me know if there is anymore information needed.