# Sports league tables

#### martyn42

##### New Member
Greetings again to members of the board.

Several of you helped me out last year when I was trying to create a spreadsheet that tracked Rugby Union scores. It was so good that I have been asked to amend it to cover Netball & Hockey (for inter school games). But they both have oddities.

In Hockey teams get 2 points for a no score draw and 3 points for a score draw.

I am using the array formula:
=SUM((\$E\$12:\$E\$23=T3)*(\$F\$12:\$F\$23<>"")*(\$F\$12:\$F\$23=\$G\$12:\$G\$23)*(1))+SUM((\$H\$12:\$H\$23=T3)*(\$G\$12:\$G\$23<>"")*(\$G\$12:\$G\$23=\$F\$12:\$F\$23)*(1))

to work out a draw, wether it is score or no score draw.

E12:E23 and H12:H23 are the teams and F12:F23 and G12:G23 are the scores.
Question how can I adapt this formula or do I need to add another column to my spread sheet?

In Netball the losing team gets 1 point for 50% or more of the winners score.

In my rugby table I used the array:
=SUM((\$E\$8:\$E\$16=V3)*(\$G\$8:\$G\$16-\$F\$8:\$F\$16<8)*(\$G\$8:\$G\$16>\$F\$8:\$F\$16)*(1))+SUM((\$H\$8:\$H\$16=V3)*(\$G\$8:\$G\$16<\$F\$8:\$F\$16)*(\$F\$8:\$F\$16-\$G\$8:\$G\$16<8)*(1))

Where E6:E16 and H6:H16 are the teams, F6:F16 and G6:G16 are the scores, which gives a bonus point for losing by 7 points or less.
Question how can I adapt this to 50% or greater?

Martyn

### Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

Replies
2
Views
243
Replies
2
Views
407
Replies
0
Views
231
Replies
7
Views
420
Legacy 143009
L
Replies
19
Views
1K

1,219,100
Messages
6,146,281
Members
450,684
Latest member
wilto1tg

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