Spreadsheet: 67242d1267817303-how-do-i-get-countif-to-be-reliable-american_idol_contest_excel_test-fixed
Sheet: Week 1 Group of 24

 | American Idol Picking Contest 2010
 | Contestant #1 Eliminated Week 1 |  |  |  |  |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 |  |  |  |  |  |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 | Contestant #2 Eliminated Week 1 |  |  |  |  |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 |  |  |  |  |  |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 | Contestant #3 Eliminated Week 1 |  |  |  |  |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 |  |  |  |  |  |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 | Contestant #4 Eliminated Week 1 |  |  |  |  |  |  | Tyler Grady | Tyler Grady | Tyler Grady | Tyler Grady | Tyler Grady | Tyler Grady | Tyler Grady | Tyler Grady | Tyler Grady | Tyler Grady | Tyler Grady | Tyler Grady | Tyler Grady | Tyler Grady | Tyler Grady
 |  |  |  |  |  |  |  | Tyler Grady | Tyler Grady | Tyler Grady | Tyler Grady | Tyler Grady | Tyler Grady | Tyler Grady | Tyler Grady | Tyler Grady | Tyler Grady | Tyler Grady | Tyler Grady | Tyler Grady | Tyler Grady | Tyler Grady
 | Eliminated Contestant Given a Bye-Week |  |  |  |  | No |  | Number of Contestants Left From Start of the Show |  |  |  |  |  |  |  |  |  |  |  |  | 24
 |  |  |  |  |  |  |  | Actual Number of Contestants Eliminated From Start of the Show |  |  |  |  |  |  |  |  |  |  |  |  | 4
 | Participant |  | Elimination Choice #1 |  | Elimination Choice #2 |  | Elimination Choice #3 |  | Elimination Choice #4 |  | Longevity Choice #1 |  | Number of   Weeks |  | Longevity Choice #2 |  | Number of   Weeks |  | Participation Points |  | Totals
1 | Bread |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | 1 |  | [NAME] | [NAME] | 1 |  | Yes |  | 700 |  | American Idol Contestants |  | Number of Times Picked to be Eliminated | Number of Times Picked to not be Eliminated
 |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 100 |  |  |  | 100 |  |  |  | 500
2 | The HOFF |  | [NAME] | [NAME] | [NAME] | [NAME] | Jermaine Sellers | Jermaine Sellers | [NAME] | [NAME] | [NAME] | [NAME] | 1 |  | [NAME] | [NAME] | 1 |  | Yes |  | 700
 |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 100 |  |  |  | 100 |  |  |  | 500 |  |  |  |  |  |  |  |  |  |  | To stay
3 | Robyn |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | 1 |  | [NAME] | [NAME] | 1 |  | Yes |  | 1900 |  | 1 | [NAME] | 2 | 2 |  |  | 1 | [NAME] | 7 | 7 | 0.35
 |  |  | 0 |  | 600 |  | 600 |  | 0 |  | 100 |  |  |  | 100 |  |  |  | 500 |  |  |  | 2 | [NAME] | 2 | 0 |  |  | 2 | [NAME] | 4 | 11 | 0.55
4 | Bananas |  | [NAME] | [NAME] | [NAME] | [NAME] | Jermaine Sellers | Jermaine Sellers | [NAME] | [NAME] | [NAME] | [NAME] | 1 |  | [NAME] | [NAME] | 1 |  | Yes |  | 1300 |  | 3 | [NAME] | 0 | 8 |  |  | 3 | [NAME] | 3 | 14 | 0.7
 |  |  | 600 |  | 0 |  | 0 |  | 0 |  | 100 |  |  |  | 100 |  |  |  | 500 |  |  |  | 4 | [NAME] | 0 | 14 |  |  | 4 | Crystal Bowersox | 2 | 16 | 0.8
5 | Enigma |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | 1 |  | [NAME] | [NAME] | 1 |  | Yes |  | 1300 |  | 5 | [NAME] | 8 | 0 |  |  | 5 | Siobhan Magnus | 2 | 18 | 0.9
 |  |  | 0 |  | 0 |  | 600 |  | 0 |  | 100 |  |  |  | 100 |  |  |  | 500 |  |  |  | 6 | Jermaine Sellers | 6 | 0 |  |  | 6 | [NAME] | 1 | 19 | 0.95
6 | Immortality |  | [NAME] | [NAME] | [NAME] | [NAME] | Jermaine Sellers | Jermaine Sellers | [NAME] | [NAME] | [NAME] | [NAME] | 1 |  | [NAME] | [NAME] | 1 |  | Yes |  | 1300 |  | 7 | [NAME] | 10 | 0 |  |  | 7 | [NAME] | 1 | 20 | 1
 |  |  | 600 |  | 0 |  | 0 |  | 0 |  | 100 |  |  |  | 100 |  |  |  | 500 |  |  |  | 8 | [NAME] | 8 | 0 |  |  | 8 | [NAME] | 0 | 20 | 1
7 | skyflake |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Siobhan Magnus | Siobhan Magnus | 1 |  | Crystal Bowersox | Crystal Bowersox | 1 |  | Yes |  | 1300 |  | 9 | [NAME] | 0 | 0 |  |  | 9 | [NAME] | 0 | 20 | 1
 |  |  | 0 |  | 600 |  | 0 |  | 0 |  | 100 |  |  |  | 100 |  |  |  | 500 |  |  |  | 10 | [NAME] | 0 | 0 |  |  | 10 | Jermaine Sellers | 0 | 20 | 1
8 | sportsgirl33 |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Crystal Bowersox | Crystal Bowersox | 1 |  | [NAME] | [NAME] | 1 |  | Yes |  | 1300 |  | 11 | [NAME] | 2 | 0 |  |  | 11 | [NAME] | 0 | 20 | 1
 |  |  | 0 |  | 0 |  | 600 |  | 0 |  | 100 |  |  |  | 100 |  |  |  | 500 |  |  |  | 12 | Tyler Grady | 2 | 0 |  |  | 12 | [NAME] | 0 | 20 | 1
9 | Hybrid |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Tyler Grady | Tyler Grady | [NAME] | [NAME] | 1 |  | Siobhan Magnus | Siobhan Magnus | 1 |  | Yes |  | 1300 |  | 13 | [NAME] | 6 | 0 |  |  | 13 | [NAME] | 0 | 20 | 1
 |  |  | 0 |  | 0 |  | 0 |  | 600 |  | 100 |  |  |  | 100 |  |  |  | 500 |  |  |  | 14 | Crystal Bowersox | 0 | 4 |  |  | 14 | [NAME] | 0 | 20 | 1
10 | Sadie |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | 1 |  | [NAME] | [NAME] | 1 |  | Yes |  | 1300 |  | 15 | [NAME] | 4 | 0 |  |  | 15 | [NAME] | 0 | 20 | 1
 |  |  | 0 |  | 0 |  | 600 |  | 0 |  | 100 |  |  |  | 100 |  |  |  | 500 |  |  |  | 16 | [NAME] | 2 | 0 |  |  | 16 | Tyler Grady | 0 | 20 | 1
11 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  | 0 |  | No |  | 0 |  | 17 | [NAME] | 2 | 0 |  |  | 17 | [NAME] | 0 | 20 | 1
 |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 18 | [NAME] | 0 | 6 |  |  | 18 | [NAME] | 0 | 20 | 1
12 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  | 0 |  | No |  | 0 |  | 19 | [NAME] | 20 | 0 |  |  | 19 | [NAME] | 0 | 20 | 1
 |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 20 | [NAME] | 2 | 0 |  |  | 20 | [NAME] | 0 | 20 | 1
13 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  | 0 |  | No |  | 0 |  | 21 | [NAME] | 0 | 0 |  |  | 21 | [NAME] | 0 | 20 | 1
 |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 22 | [NAME] | 4 | 0 |  |  | 22 | [NAME] | 0 | 20 | 1
14 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  | 0 |  | No |  | 0 |  | 23 | Siobhan Magnus | 0 | 4 |  |  | 23 | [NAME] | 0 | 20 | 1
 |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 24 | [NAME] | 0 | 2 |  |  | 24 | [NAME] | 0 | 20 | 1
15 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  | 0 |  | No |  | 0 |  |  |  |  |  |  |  |  |  | 20
 |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0 |  |  |  | 0
16 |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  | 1 |  | Yes |  | 700
 |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 100 |  |  |  | 100 |  |  |  | 500
17 |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  | 1 |  | Yes |  | 700
 |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 100 |  |  |  | 100 |  |  |  | 500
18 |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  | 1 |  | Yes |  | 700
 |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 100 |  |  |  | 100 |  |  |  | 500 |  |  |  |  |  |  |  |  |  |  | Guys getting the boot
19 |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  | 1 |  | Yes |  | 700 |  |  |  |  |  |  |  | 1 | [NAME] | 5 | 5 | 0.25
 |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 100 |  |  |  | 100 |  |  |  | 500 |  |  |  |  |  |  |  |  |  | 2 | [NAME] | 4 | 9 | 0.45
20 |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  | 1 |  | Yes |  | 700 |  |  |  |  |  |  |  | 3 | [NAME] | 4 | 13 | 0.65
 |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 100 |  |  |  | 100 |  |  |  | 500 |  |  |  |  |  |  |  |  |  | 4 | Jermaine Sellers | 3 | 16 | 0.8
21 |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  | 1 |  | Yes |  | 700 |  |  |  |  |  |  |  | 5 | [NAME] | 1 | 17 | 0.85
 |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 100 |  |  |  | 100 |  |  |  | 500 |  |  |  |  |  |  |  |  |  | 6 | [NAME] | 1 | 18 | 0.9
22 |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  | 1 |  | Yes |  | 700 |  |  |  |  |  |  |  | 7 | [NAME] | 1 | 19 | 0.95
 |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 100 |  |  |  | 100 |  |  |  | 500 |  |  |  |  |  |  |  |  |  | 8 | Tyler Grady | 1 | 20 | 1
23 |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  | 1 |  | Yes |  | 700 |  |  |  |  |  |  |  | 9 | [NAME] | 0 | 20 | 1
 |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 100 |  |  |  | 100 |  |  |  | 500 |  |  |  |  |  |  |  |  |  | 10 | [NAME] | 0 | 20 | 1
24 |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  | 1 |  | Yes |  | 700 |  |  |  |  |  |  |  | 11 | [NAME] | 0 | 20 | 1
 |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 100 |  |  |  | 100 |  |  |  | 500 |  |  |  |  |  |  |  |  |  | 12 | [NAME] | 0 | 20 | 1
25 |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  | 1 |  | Yes |  | 700 |  |  |  |  |  |  |  |  |  | 20
 |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 100 |  |  |  | 100 |  |  |  | 500
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | [NAME] | 10 | 10 | 0.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | [NAME] | 3 | 13 | 0.65
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | [NAME] | 2 | 15 | 0.75
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | [NAME] | 2 | 17 | 0.85
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | [NAME] | 1 | 18 | 0.9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | [NAME] | 1 | 19 | 0.95
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | [NAME] | 1 | 20 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | Crystal Bowersox | 0 | 20 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | [NAME] | 0 | 20 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | [NAME] | 0 | 20 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11 | Siobhan Magnus | 0 | 20 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | [NAME] | 0 | 20 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20