Spreadsheet: 714535d1611262043-need-help-writing-a-formula-to-sum-only-highest-numbers-in-lists-formula-help-example
Sheet: Sheet1

Handler | Dog | Trial Points | Total Points | # Trials | 5 | 10 | 15
Abbi | Duck | 250 |  |  | 250
Abbi | Reba | 430 |  |  | 430
[NAME] | Mirc | 550 |  |  | 590
[NAME] | Mirc | 30
[NAME] | Mirc | 10
[NAME] | Ace | 140 |  |  | 140
[NAME] | [NAME] | 40 |  |  | 40
[NAME] | [NAME]* | 210 |  |  | 220
[NAME] | [NAME]* | 10
[NAME] | Ace | 240 |  |  | 370
[NAME] | Ace | 110
[NAME] | Ace | 10
[NAME] | Ace | 10
[NAME] | Ellie | 490 |  |  | 1960 | 2670
[NAME] | Ellie | 440
[NAME] | Ellie | 390
[NAME] | Ellie | 340
[NAME] | Ellie | 300
[NAME] | Ellie | 210
[NAME] | Ellie | 210
[NAME] | Ellie | 210
[NAME] | Ellie | 40
[NAME] | Ellie | 40
[NAME] | Jazz* | 690 |  |  | 1260 | 1260
[NAME] | Jazz* | 240
[NAME] | Jazz* | 110
[NAME] | Jazz* | 110
[NAME] | Jazz* | 110
[NAME] | Zoey* | 340
[NAME] | Toby | 550
[NAME] | Toby | 480
[NAME] | Toby | 370
[NAME] | Toby | 350
[NAME] | Tuff | 850
[NAME] | Tuff | 450
[NAME] | Tuff | 440
[NAME] | Tuff | 70
[NAME] | Slik | 950
[NAME] | Slik | 280
[NAME] | Slik | 180
[NAME] | Slik | 140
[NAME] | Slik | 40
[NAME] | Slink | 440
[NAME] | Slink | 440
[NAME] | Slink | 380
[NAME] | Slink | 90
[NAME] | Zig | 1050
[NAME] | Zig | 570
[NAME] | Zig | 140
Brent | [NAME] | 30
Brent | Si | 630
[NAME] | [NAME] | 290
[NAME] | [NAME] | 230
[NAME] | Quinn | 570
[NAME] | Quinn | 190
[NAME] | Quinn | 130
[NAME] | Wit | 290
[NAME] | [NAME] | 240
[NAME] | Macie* | 250
[NAME] | Macie* | 240
[NAME] | Macie* | 210
[NAME] | Macie* | 180
[NAME] | Macie* | 180
[NAME] | Priya* | 420
[NAME] | Priya* | 140
[NAME] | Romel | 480
[NAME] | Romel | 380
[NAME] | Romel | 240
[NAME] | Romel | 190
[NAME] | Romel | 150
[NAME] | Romel | 140
[NAME] | Romel | 120
[NAME] | Romel | 80
[NAME] | Romel | 40
[NAME] | Romel | 40
[NAME] | Ruby* | 360
[NAME] | Ruby* | 260
[NAME] | Ruby* | 40
[NAME] | Zigman* | 480
Buzz | [NAME] | 430
Buzz | [NAME] | 310
Buzz | [NAME] | 190
Buzz | Roxy | 230
Buzz | Roxy | 30
Buzz | Sid | 630
Buzz | Sid | 330
Campbell | Mac | 440
Campbell | Mac | 240
Campbell | Mac | 40
[NAME] | Tuff | 500
[NAME] | Tuff | 190
[NAME] | Tuff | 170
[NAME] | Tuff | 130
[NAME] | Atta | 280
[NAME] | Atta | 260
[NAME] | Atta | 240
[NAME] | Atta | 200
[NAME] | Atta | 160
[NAME] | Atta | 160
[NAME] | Chip | 390
[NAME] | Chip | 280
[NAME] | Chip | 260
[NAME] | Chip | 160
[NAME] | Chip | 80
[NAME] | Chip | 40
[NAME] | Chip | 20
[NAME] | Bet | 710
[NAME] | Bet | 130
[NAME] | Hawk | 730
[NAME] | Hawk | 530
[NAME] | Jaff | 680
[NAME] | Jaff | 330
[NAME] | Jaff | 130
[NAME] | Jaff | 50
Curtis | Brin | 540
Curtis | Brin | 290
Curtis | Brin | 240
Curtis | Brin | 140
Curtis | Brin | 140
Curtis | Brin | 10
[NAME] | Ren | 300
[NAME] | Cat | 450
[NAME] | Dodge | 490
[NAME] | Dodge | 200
[NAME] | Dodge | 110
[NAME] | Mack | 500
[NAME] | Mack | 280
[NAME] | Penny* | 630
[NAME] | Penny* | 430
[NAME] | Skip | 320
Dottie | [NAME] | 380
Dottie | [NAME] | 340
Dottie | [NAME] | 250
Dottie | [NAME] | 150
Dottie | [NAME] | 70
Dottie | [NAME] | 70
Dottie | [NAME] | 40
Dottie | Shane* | 50
Duane | Smoke | 200
Duane | Smoke | 150
Duane | Smoke | 50
Eddie | Kayt | 550
Eddie | Kayt | 390
Eddie | Kayt | 370
[NAME] | [NAME] | 150
Hans | [NAME] | 140
[NAME] | Dolly | 930
[NAME] | Dolly | 830
[NAME] | Dolly | 800
[NAME] | Dolly | 700
[NAME] | Dolly | 650
[NAME] | Dolly | 560
[NAME] | Dolly | 530
[NAME] | Dolly | 450
[NAME] | Dolly | 430
[NAME] | Dolly | 410
[NAME] | Dolly | 350
[NAME] | Dolly | 280
[NAME] | Dolly | 200
[NAME] | Dolly | 60
[NAME] | Eli | 900
[NAME] | Eli | 780
[NAME] | Eli | 730
[NAME] | Eli | 610
[NAME] | Eli | 510
[NAME] | Eli | 460
[NAME] | Eli | 330
[NAME] | Eli | 160
[NAME] | Eli | 90
[NAME] | [NAME] | 830
[NAME] | [NAME] | 830
[NAME] | [NAME] | 810
[NAME] | [NAME] | 600
[NAME] | [NAME] | 530
[NAME] | [NAME] | 430
[NAME] | [NAME] | 400
[NAME] | [NAME] | 210
[NAME] | [NAME] | 210
[NAME] | [NAME] | 180
Jan | Zoe | 240
Jan | Zoe | 170
Jan | Zoe | 80
Jan | Zoe | 80
[NAME] | Pig | 410
[NAME] | Duke | 150
[NAME] | Greta | 750
[NAME] | Scootch* | 40
[NAME] | Okie | 860
[NAME] | Okie | 730
[NAME] | Okie | 450
[NAME] | Okie | 190
[NAME] | Okie | 150
[NAME] | War | 250
[NAME] | War | 150
[NAME] | [NAME] | 340
[NAME] | Kero | 590
[NAME] | Kero | 440
[NAME] | Kero | 240
[NAME] | Kero | 130
[NAME] | Kero | 40
[NAME] | Monster* | 240
Juan | Pancho | 800
Juan | Pancho | 700
Juan | Pancho | 540
Juan | Pancho | 540
[NAME] | Gayle | 140
[NAME] | Gayle | 40
[NAME] | Jade | 240
[NAME] | Jade | 140
[NAME] | Angus | 420
[NAME] | Angus | 210
[NAME] | Reo | 380
Kelly | Blue | 490
Kelly | Blue | 250
Kelly | Blue | 180
[NAME] | Jake | 100
[NAME] | Chock | 710
[NAME] | Chock | 650
[NAME] | Chock | 530
[NAME] | Chock | 400
[NAME] | Chock | 140
[NAME] | Chock | 80
[NAME] | Chock | 50
[NAME] | Steele | 690
[NAME] | Steele | 690
[NAME] | Steele | 630
[NAME] | Steele | 450
[NAME] | Steele | 380
[NAME] | Steele | 350
[NAME] | Steele | 330
[NAME] | Steele | 310
[NAME] | Steele | 270
[NAME] | Steele | 250
[NAME] | Steele | 230
[NAME] | Steele | 150
[NAME] | Steele | 110
[NAME] | Steele | 60
[NAME] | Chain | 250
[NAME] | Chain | 50
[NAME] | Hammer | 250
[NAME] | Hammer | 90
[NAME] | Hammer | 50
[NAME] | [NAME] | 700
Lincoln | Skeet | 20
Lincoln | [NAME]* | 930
Lincoln | [NAME]* | 810
Lincoln | [NAME]* | 480
Lincoln | [NAME]* | 220
[NAME] | Will | 150
Marcel | Jock | 540
Marcel | Jock | 350
Marcel | Jock | 290
Marcel | Jock | 90
Marcel | Jock | 40
Maycon | Booner | 650
Maycon | Booner | 590
Maycon | Booner | 450
Maycon | Booner | 130
Maycon | Fuzil* | 350
Maycon | Fuzil* | 330
Maycon | Fuzil* | 30
Maycon | [NAME]* | 230
[NAME] | [NAME]* | 450
[NAME] | [NAME]* | 380
[NAME] | [NAME]* | 60
[NAME] | [NAME]* | 30
[NAME] | Rip* | 360
[NAME] | Rip* | 330
[NAME] | Rip* | 320
[NAME] | Rip* | 290
[NAME] | Rip* | 280
[NAME] | Rip* | 50
[NAME] | Rip* | 10
[NAME] | Sue | 180
[NAME] | Archie | 310
[NAME] | Mady | 510
[NAME] | Hank | 50
[NAME] | Vi | 260
[NAME] | [NAME] | 540
[NAME] | [NAME] | 340
[NAME] | [NAME] | 40
[NAME] | Spot* | 440
Pam | Bess | 190
[NAME] | [NAME] | 220
[NAME] | [NAME] | 180
[NAME] | [NAME] | 690
[NAME] | [NAME] | 540
[NAME] | [NAME] | 450
[NAME] | [NAME] | 390
[NAME] | [NAME] | 340
[NAME] | [NAME] | 340
[NAME] | [NAME] | 190
[NAME] | Cat | 900
[NAME] | Cat | 800
[NAME] | [NAME] | 100
Remy | [NAME] | 340
Remy | [NAME] | 240
Rich | Ky | 750
Rich | Ky | 300
Rich | [NAME] | 900
Rich | [NAME] | 750
Rich | [NAME] | 690
Rich | [NAME] | 540
Rich | [NAME] | 500
Rich | [NAME] | 480
Rich | [NAME] | 470
Rich | [NAME] | 270
Rich | [NAME] | 240
Rich | Skip | 570
Rich | Skip | 480
Rich | Skip | 340
Rich | Skip | 280
Rich | Skip | 270
Rich | Skip | 240
Rich | Skip | 170
[NAME] | Dottie | 600
[NAME] | Dottie | 500
[NAME] | [NAME] | 300
[NAME] | Roper | 800
[NAME] | Roper | 530
[NAME] | Roper | 510
[NAME] | Roper | 490
[NAME] | Roper | 360
[NAME] | Roper | 260
[NAME] | [NAME] | 760
[NAME] | [NAME] | 750
[NAME] | [NAME] | 290
[NAME] | Reinee | 100
[NAME] | [NAME]* | 450
[NAME] | [NAME]* | 350
[NAME] | [NAME]* | 230
[NAME] | [NAME]* | 10
Rose | Chick | 300
Rose | Chick | 50
Rose | Taz | 240
Sara-Jo | Hank | 140
Sara-Jo | Molly | 140
Sara-Jo | Molly | 40
Sara-Jo | Pace | 240
Sara-Jo | Pace | 240
Sean | [NAME] | 480
[NAME] | [NAME] | 340
[NAME] | [NAME] | 50
[NAME] | Rogue | 950
[NAME] | Rogue | 810
[NAME] | Rogue | 440
[NAME] | Rogue | 340
[NAME] | Toad | 540
[NAME] | Toad | 400
[NAME] | Toad | 140
[NAME] | Dillon* | 600
[NAME] | Dillon* | 150
[NAME] | Dillon* | 10
[NAME] | Duck | 1050
[NAME] | Duck | 850
[NAME] | Duck | 610
[NAME] | Duck | 500
[NAME] | Duck | 410
[NAME] | Duck | 230
[NAME] | Duck | 160
[NAME] | Duck | 80
[NAME] | Duck | 40
[NAME] | [NAME] | 930
[NAME] | [NAME] | 900
[NAME] | [NAME] | 600
[NAME] | [NAME] | 580
[NAME] | [NAME] | 550
[NAME] | [NAME] | 550
[NAME] | [NAME] | 540
[NAME] | [NAME] | 460
[NAME] | [NAME] | 380
[NAME] | [NAME] | 350
[NAME] | [NAME] | 140
[NAME] | [NAME] | 110
[NAME] | [NAME] | 100
[NAME] | [NAME] | 50
[NAME] | [NAME] | 30
[NAME] | [NAME]* | 100
[NAME] | [NAME] | 610
[NAME] | [NAME] | 150
[NAME] | [NAME] | 130
[NAME] | [NAME] | 90
[NAME] | [NAME] | 750
[NAME] | [NAME] | 590
[NAME] | [NAME] | 470
[NAME] | [NAME] | 470
[NAME] | [NAME] | 300
[NAME] | [NAME] | 30
[NAME] | Queen | 400
[NAME] | Queen | 370