Spreadsheet: 141768d1329432779-countif-or-other-option-copy-of-randombasicstrategychart
Sheet: Sheet1

 |  |  |  | 6 [NAME] shoe [NAME], Double After Split, Surrender-RANDOMIZED |  |  |  |  |  |  |  |  |  |  |  |  | 6 [NAME] shoe [NAME], Double After [NAME], Surrender
 |  |  | Player's Hand | Dealers Upcard |  |  |  |  |  |  |  |  |  |  |  | Player's Hand | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | A
 |  |  |  | 2 | 3 | 6 | A | 7 | 10 | 8 | 9 | 5 | 4 |  | Player's Cards | Ace, Ace | Sp | Sp | Sp | Sp | Sp | Sp | Sp | Sp | Sp | Sp
 |  |  | Ace, 2 | H | H | D | H | H | H | H | H | D | H |  |  | 2, 2 | Sp | Sp | Sp | Sp | Sp | Sp | H | H | H | H
 |  |  | 10 | D | D | D | H | D | H | D | D | D | D |  |  | 3, 3 | Sp | Sp | Sp | Sp | Sp | Sp | H | H | H | H
 |  |  | 3, 3 | Sp | Sp | Sp | H | Sp | H | H | H | Sp | Sp |  |  | 4, 4 | H | H | H | Sp | Sp | H | H | H | H | H
 |  |  | 8 | H | H | H | H | H | H | H | H | H | H |  |  | 5, 5 | D | D | D | D | D | D | D | D | H | H
 |  |  | 9, 9 | Sp | Sp | Sp | S | S | S | Sp | Sp | Sp | Sp |  |  | 6, 6 | Sp | Sp | Sp | Sp | Sp | H | H | H | H | H
 |  |  | Ace, 7 | S | D | D | H | S | H | S | H | D | D |  |  | 7, 7 | Sp | Sp | Sp | Sp | Sp | Sp | H | H | H | H
 |  |  | 5, 6, 7 | H | H | H | H | H | H | H | H | H | H |  |  | 8, 8 | Sp | Sp | Sp | Sp | Sp | Sp | Sp | Sp | Sp | Sp
 |  |  | 10, 10 | S | S | S | S | S | S | S | S | S | S |  |  | 9, 9 | Sp | Sp | Sp | Sp | Sp | S | Sp | Sp | S | S
 |  |  | 12 | H | H | S | H | H | H | H | H | S | S |  |  | 10, 10 | S | S | S | S | S | S | S | S | S | S
 |  |  | 14 | S | S | S | H | H | H | H | H | S | S |  |  |  | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | Ace
 |  |  | Ace, 5 | H | H | D | H | H | H | H | H | D | D |  |  | Ace, 2 | H | H | H | D | D | H | H | H | H | H
 |  |  | Ace, 3 | H | H | D | H | H | H | H | H | D | H |  |  | Ace, 3 | H | H | H | D | D | H | H | H | H | H
 |  |  | 4, 4 | H | H | Sp | H | H | H | H | H | Sp | H |  |  | Ace, 4 | H | H | D | D | D | H | H | H | H | H
 |  |  | 9 | H | D | D | H | H | H | H | H | D | D |  |  | Ace, 5 | H | H | D | D | D | H | H | H | H | H
300 total decisions |  |  | 16 | S | S | S | X | H | X | H | X | S | S |  |  | Ace, 6 | H | D | D | D | D | H | H | H | H | H
 |  |  | 17 | S | S | S | S | S | S | S | S | S | S |  |  | Ace, 7 | S | D | D | D | D | S | S | H | H | H
 |  |  | 7, 7 | Sp | Sp | Sp | H | Sp | H | H | H | Sp | Sp |  |  | Ace, 8 | S | S | S | S | S | S | S | S | S | S
 |  |  | 15 | S | S | S | H | H | X | H | H | S | S |  |  | Ace, 9 | S | S | S | S | S | S | S | S | S | S
 |  |  | Ace, Ace | Sp | Sp | Sp | Sp | Sp | Sp | Sp | Sp | Sp | Sp |  |  |  | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | Ace
 |  |  | 18-21 | S | S | S | S | S | S | S | S | S | S |  |  | 5, 6, 7 | H | H | H | H | H | H | H | H | H | H
 |  |  | 2, 2 | Sp | Sp | Sp | H | Sp | H | H | H | Sp | Sp |  |  | 8 | H | H | H | H | H | H | H | H | H | H
 |  |  | Ace, 9 | S | S | S | S | S | S | S | S | S | S |  |  | 9 | H | D | D | D | D | H | H | H | H | H
 |  |  | Ace, 6 | H | D | D | H | H | H | H | H | D | D |  |  | 10 | D | D | D | D | D | D | D | D | H | H
 |  |  | 11 | D | D | D | D+1 | D | D | D | D | D | D |  |  | 11 | D | D | D | D | D | D | D | D | D | D+1
 |  |  | 5, 5 | D | D | D | H | D | H | D | D | D | D |  |  | 12 | H | H | S | S | S | H | H | H | H | H
 |  |  | 6, 6 | Sp | Sp | Sp | H | H | H | H | H | Sp | Sp |  |  | 13 | S | S | S | S | S | H | H | H | H | H
 |  |  | 8, 8 | Sp | Sp | Sp | Sp | Sp | Sp | Sp | Sp | Sp | Sp |  |  | 14 | S | S | S | S | S | H | H | H | H | H
 |  |  | Ace, 4 | H | H | D | H | H | H | H | H | D | D |  |  | 15 | S | S | S | S | S | H | H | H | X | H
 |  |  | 13 | S | S | S | H | H | H | H | H | S | S |  |  | 16 | S | S | S | S | S | H | H | X | X | X
 |  |  | Ace, 8 | S | S | S | S | S | S | S | S | S | S |  |  | 17 | S | S | S | S | S | S | S | S | S | S
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18-21 | S | S | S | S | S | S | S | S | S | S
 |  | IF(E8=Sheet2!E8,1,"")
 |  | return 1 if correct |  | 1
 |  | space if not
 |  |  | Correct | 1 |  |  |  |  | 1 | Correct only
 |  |  | Wrong | 299 |  |  |  |  |  | we cannot sum wrong co'z  0 + 0 = 0
 |  |  |  |  |  |  |  |  | SUMIF(E42:N71,"=1",E42:N71) |  |  |  |  |  |  | H | H | D | D | D | D | D | D | D | D
 |  |  | correct | COUNTIF(E42:N71,"=1")
 |  |  | wrong | COUNTIF(E42:N71,"<>1")