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

 | American Idol Picking Contest 2010
 | Contestant #1 Eliminated Week 2 |  |  |  |  |  |  | [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 2 |  |  |  |  |  |  | [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 2 |  |  |  |  |  |  | [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 2 |  |  |  |  |  |  | Jermaine Sellers | Jermaine Sellers | Jermaine Sellers | Jermaine Sellers | Jermaine Sellers | Jermaine Sellers | Jermaine Sellers | Jermaine Sellers | Jermaine Sellers | Jermaine Sellers | Jermaine Sellers | Jermaine Sellers | Jermaine Sellers | Jermaine Sellers | Jermaine Sellers
 |  |  |  |  |  |  |  | Jermaine Sellers | Jermaine Sellers | Jermaine Sellers | Jermaine Sellers | Jermaine Sellers | Jermaine Sellers | Jermaine Sellers | Jermaine Sellers | Jermaine Sellers | Jermaine Sellers | Jermaine Sellers | Jermaine Sellers | Jermaine Sellers | Jermaine Sellers | Jermaine Sellers
 | Eliminated Contestant Given a Bye-Week |  |  |  |  | No |  | Number of Contestants Left From Start of the Show |  |  |  |  |  |  |  |  |  |  |  |  | 20
 |  |  |  |  |  |  |  | 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 for the Week |  | Grand Total
1 | Bread |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | Siobhan Magnus | Siobhan Magnus | 1 |  | [NAME] | [NAME] | 1 |  | Yes |  | 1700 |  | 2400 |  | American Idol Contestants |  | Number of Times Picked to be Eliminated | Number of Times Picked to not be Eliminated
 |  |  | 0 |  | 500 |  | 500 |  | 0 |  | 100 |  |  |  | 100 |  |  |  | 500
2 | The HOFF |  | [NAME] |  | [NAME] |  | [NAME] |  | Jermaine Sellers |  | [NAME] | [NAME] | 1 |  | Crystal Bowersox | Crystal Bowersox | 1 |  | Yes |  | 1200 |  | 1900
 |  |  | 0 |  | 0 |  | 0 |  | 500 |  | 100 |  |  |  | 100 |  |  |  | 500 |  |  |  |  |  |  |  |  |  |  |  | To Stay
3 | Robyn |  | [NAME] |  | [NAME] |  | [NAME] |  | Jermaine Sellers |  | [NAME] |  | 2 |  | Siobhan Magnus | Siobhan Magnus | 1 |  | Yes |  | 2300 |  | 4200 |  | 1 | [NAME] | 0 | 1 |  | 1 | [NAME] | 1 | 1
 |  |  | 0 |  | 500 |  | 500 |  | 500 |  | 200 |  |  |  | 100 |  |  |  | 500 |  |  |  |  |  | 2 | [NAME] | 3 | 0 |  | 2 | [NAME] | 0 | 1
4 | Bananas |  |  |  |  |  |  |  |  |  | [NAME] |  | 2 |  | [NAME] |  | 2 |  | Yes |  | 900 |  | 2200 |  | 3 | [NAME] | 0 | 1 |  | 3 | [NAME] | 1 | 2
 |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 200 |  |  |  | 200 |  |  |  | 500 |  |  |  |  |  | 4 | [NAME] | 0 | 5 |  | 4 | [NAME] | 5 | 7
5 | Enigma |  | [NAME] |  | [NAME] |  | [NAME] |  | Jermaine Sellers |  | Crystal Bowersox | Crystal Bowersox | 1 |  | [NAME] | [NAME] | 1 |  | Yes |  | 2200 |  | 3500 |  | 5 | [NAME] | 1 | 0 |  | 5 | [NAME] | 0 | 7
 |  |  | 500 |  | 0 |  | 500 |  | 500 |  | 100 |  |  |  | 100 |  |  |  | 500 |  |  |  |  |  | 6 | Jermaine Sellers | 4 | 0 |  | 6 | Jermaine Sellers | 0 | 7
6 | Immortality |  | [NAME] |  | [NAME] |  | Jermaine Sellers |  | [NAME] |  | [NAME] |  | 2 |  | [NAME] |  | 2 |  | Yes |  | 1900 |  | 3200 |  | 7 | [NAME] | 7 | 0 |  | 7 | [NAME] | 0 | 7
 |  |  | 0 |  | 0 |  | 500 |  | 500 |  | 200 |  |  |  | 200 |  |  |  | 500 |  |  |  |  |  | 8 | [NAME] | 0 | 4 |  | 8 | [NAME] | 4 | 11
7 | skyflake |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | Siobhan Magnus |  | 2 |  | Crystal Bowersox |  | 2 |  | Yes |  | 1400 |  | 2700 |  | 9 | [NAME] | 0 | 0 |  | 9 | [NAME] | 0 | 11
 |  |  | 0 |  | 0 |  | 0 |  | 500 |  | 200 |  |  |  | 200 |  |  |  | 500 |  |  |  |  |  | 10 | [NAME] | 5 | 0 |  | 10 | [NAME] | 0 | 11
8 | sportsgirl33 |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | Crystal Bowersox |  | 2 |  | [NAME] |  | 2 |  | Yes |  | 1900 |  | 3200 |  | 11 | Crystal Bowersox | 0 | 10 |  | 11 | Crystal Bowersox | 10 | 21
 |  |  | 500 |  | 0 |  | 500 |  | 0 |  | 200 |  |  |  | 200 |  |  |  | 500 |  |  |  |  |  | 12 | [NAME] | 7 | 0 |  | 12 | [NAME] | 0 | 21
9 | Hybrid |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | 2 |  | Siobhan Magnus |  | 2 |  | Yes |  | 1400 |  | 2700 |  | 13 | [NAME] | 0 | 0 |  | 13 | [NAME] | 0 | 21
 |  |  | 500 |  | 0 |  | 0 |  | 0 |  | 200 |  |  |  | 200 |  |  |  | 500 |  |  |  |  |  | 14 | [NAME] | 0 | 3 |  | 14 | [NAME] | 3 | 24
10 | Sadie |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | Crystal Bowersox | Crystal Bowersox | 1 |  | [NAME] |  | 2 |  | Yes |  | 1800 |  | 3100 |  | 15 | [NAME] | 9 | 0 |  | 15 | [NAME] | 0 | 24
 |  |  | 0 |  | 500 |  | 500 |  | 0 |  | 100 |  |  |  | 200 |  |  |  | 500 |  |  |  |  |  | 16 | [NAME] | 0 | 2 |  | 16 | [NAME] | 2 | 26
11 | Meangirl32 |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | Crystal Bowersox | Crystal Bowersox | 1 |  | [NAME] | [NAME] | 1 |  | Yes |  | 1200 |  | 1200 |  | 17 | [NAME] | 0 | 0 |  | 17 | [NAME] | 0 | 26
 |  |  | 0 |  | 500 |  | 0 |  | 0 |  | 100 |  |  |  | 100 |  |  |  | 500 |  |  |  |  |  | 18 | [NAME] | 1 | 0 |  | 18 | [NAME] | 0 | 26
12 | 0 |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | No |  | 0 |  | 0 |  | 19 | Siobhan Magnus | 0 | 6 |  | 19 | Siobhan Magnus | 6 | 32
 |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  |  |  | 20 | [NAME] | 3 | 0 |  | 20 | [NAME] | 0 | 32
13 | 0 |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | No |  | 0 |  | 0 |  |  |  | 40 | 32
 |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0 |  |  |  | 0
14 | 0 |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | No |  | 0 |  | 0
 |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0 |  |  |  | 0
15 | 0 |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | No |  | 0 |  | 0
 |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0 |  |  |  | 0