Spreadsheet: 542374d1507826036-automate-this-table-automate-this-table-auto-2
Sheet: Results

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Copy and Paste Values into
Just put new result in the table below |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME], space, Result, space, [NAME] to calculate table to the right | Note [NAME] and [NAME] are not =
 |  |  |  |  |  |  |  | Use a sumproduct to do the math automatically as you update the results in the table |  |  |  |  |  |  |  |  |  |  | Results(note home player is always first ) | Home Team | Result | Away Team | Result |  |  |  |  |  | won | won | lost
Name | Result | Lookup value | Played | Result | Points |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] won don |  |  |  |  |  |  |  |  |  | los | lost | won away
[NAME] | won |  |  | won | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] lost willy |  |  |  |  |  |  |  |  |  | dre | drew | drew
[NAME] | lost |  |  | lost | 0 |  |  | Name | Played | won | lost | drew | won away | Points |  |  |  |  | Scully won gary
Scully | won |  |  | drew | 1 |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  | [NAME] lost gary
[NAME] | lost |  |  | won away | 4 |  |  | [NAME] |  |  |  |  |  |  | 4 |  |  |  | [NAME] drew [NAME]
[NAME] | drew |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  | [NAME] lost gary
[NAME] | lost |  |  |  |  |  |  | [NAME]
[NAME] | lost |  |  |  |  |  |  | [NAME]
Willy | won away |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
[NAME] | lost |  |  |  |  |  |  | Damon |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Damon
[NAME] | won away |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  | Use Dropdowns for data validations |  |  | Past results Below for Sumproduct Table to work |  |  |  |  |  |  | [NAME]
[NAME] | drew |  |  |  |  |  |  | Willy |  |  |  |  |  |  |  |  |  |  | Home Team (Pick from the Listing) | Result | Away Team (Pick from the Listing) |  |  |  |  |  |  |  | [NAME]
[NAME] | won away |  |  |  |  |  |  | Scully |  |  |  |  |  |  |  |  |  |  | [NAME] | won | [NAME] |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  | [NAME] | lost | Willy |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  | Scully | won | [NAME] |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | [NAME] B |  |  |  |  |  |  |  |  |  |  | [NAME] | lost | [NAME] |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  | [NAME] | drew | [NAME] |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  | [NAME] | lost | [NAME] |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Scully
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] B
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Willy
 |  |  |  |  |  |  |  | Use a Pivot table to pull the results.  You will have to refresh the table each time you add results.
 |  |  |  |  |  |  |  | Sum of Lookup value | Column Labels
 |  |  |  |  |  |  |  | Row Labels | won | lost | drew | won away | Grand Total |  |  |  |  |  | [NAME] | won
 |  |  |  |  |  |  |  | [NAME] |  | 0 |  |  | 0 |  |  |  |  |  | [NAME] | lost
 |  |  |  |  |  |  |  | [NAME] |  | 0 |  | 8 | 8 |  |  |  |  |  | [NAME] | lost
 |  |  |  |  |  |  |  | [NAME] | 3 | 0 |  |  | 3 |  |  |  |  |  | [NAME] | lost
 |  |  |  |  |  |  |  | [NAME] |  | 0 |  |  | 0 |  |  |  |  |  | [NAME] | won away
 |  |  |  |  |  |  |  | Scully | 3 |  |  |  | 3 |  |  |  |  |  | [NAME] | won away
 |  |  |  |  |  |  |  | [NAME] |  |  | 1 |  | 1 |  |  |  |  |  | Willy | won away
 |  |  |  |  |  |  |  | Willy |  |  |  | 4 | 4 |  |  |  |  |  | Scully | won
 |  |  |  |  |  |  |  | Grand Total | 6 | 0 | 1 | 12 | 19 |  |  |  |  |  | [NAME] | drew
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | lost
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | lost
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | lost