Spreadsheet: 824994d1681017943-how-can-i-tweak-this-formula-to-count-when-it-is-0-and-100-book2
Sheet: Sheet1

Date | Tm | G | PA | AB | H | 1B | 2B | 3B | HR | R | RBI | BB | IBB | SO | HBP | SF | SH | GDP | SB | CS | AVG
2023-04-06 00:00:00 | WSN | 3 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2023-04-06 00:00:00 | TOR | 5 | 5 | 5 | 2 | 1 | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0.4
2023-04-06 00:00:00 | LAD | 6 | 6 | 5 | 2 | 2 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.4
2023-04-06 00:00:00 | SFG | 5 | 5 | 5 | 2 | 0 | 1 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.4 |  |  |  |  | Team City | Team | Wins | Loss | Pct | Streak
2023-04-06 00:00:00 | SDP | 4 | 4 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2023-04-06 00:00:00 | BOS | 3 | 3 | 3 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0.33333333 |  |  |  |  |  | ATL
2023-04-05 00:00:00 | TOR | 4 | 4 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  | BAL
2023-04-05 00:00:00 | ATL | 4 | 4 | 4 | 1 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.25 |  |  |  |  |  | BOS
2023-04-05 00:00:00 | SFG | 4 | 4 | 4 | 1 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0.25 |  |  |  |  |  | CHC
2023-04-05 00:00:00 | LAA | 5 | 5 | 5 | 2 | 1 | 0 | 0 | 1 | 2 | 2 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0.4 |  |  |  |  |  | CHW
2023-04-05 00:00:00 | MIN | 3 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  | CLE
2023-04-05 00:00:00 | BAL | 3 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  | COL
2023-04-05 00:00:00 | PHI | 4 | 4 | 4 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0.25 |  |  |  |  |  | DET
2023-04-05 00:00:00 | NYM | 3 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  | LAA
2023-04-05 00:00:00 | CLE | 5 | 5 | 5 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0.2 |  |  |  |  |  | LAD
2023-04-05 00:00:00 | PIT | 3 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  | MIL
2023-04-05 00:00:00 | DET | 3 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  | MIN
2023-04-05 00:00:00 | TBR | 6 | 6 | 5 | 3 | 3 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0.6 |  |  |  |  |  | NYM
2023-04-04 00:00:00 | CHC | 3 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  | PHI
2023-04-04 00:00:00 | PIT | 6 | 6 | 5 | 1 | 0 | 0 | 0 | 1 | 2 | 2 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0.2 |  |  |  |  |  | PIT
2023-04-04 00:00:00 | BAL | 8 | 8 | 7 | 4 | 2 | 1 | 0 | 1 | 5 | 5 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0.57142857 |  |  |  |  |  | SDP
2023-04-04 00:00:00 | COL | 4 | 4 | 4 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0.25 |  |  |  |  |  | SFG
2023-04-04 00:00:00 | ARI | 5 | 5 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 0 |  |  |  |  |  | TBR
2023-04-04 00:00:00 | PHI | 3 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  | TOR
2023-04-04 00:00:00 | ATL | 5 | 5 | 5 | 2 | 1 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0.4 |  |  |  |  |  | WSN
2023-04-04 00:00:00 | LAA | 3 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2023-04-04 00:00:00 | TBR | 4 | 4 | 4 | 1 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0.25
2023-04-04 00:00:00 | NYM | 4 | 4 | 4 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0.25
2023-04-04 00:00:00 | CLE | 3 | 3 | 3 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0.33333333
2023-04-04 00:00:00 | TOR | 4 | 4 | 4 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0.25
2023-04-04 00:00:00 | MIN | 3 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2023-04-04 00:00:00 | DET | 3 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2023-04-03 00:00:00 | CLE | 3 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2023-04-03 00:00:00 | TBR | 5 | 5 | 4 | 2 | 2 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0.5
2023-04-03 00:00:00 | ATL | 9 | 9 | 8 | 5 | 2 | 1 | 0 | 2 | 5 | 5 | 1 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0.625
2023-04-03 00:00:00 | MIN | 6 | 6 | 5 | 2 | 1 | 0 | 0 | 1 | 3 | 3 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.4
2023-04-03 00:00:00 | TOR | 5 | 5 | 4 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0.25
2023-04-03 00:00:00 | ARI | 5 | 5 | 5 | 3 | 3 | 0 | 0 | 0 | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0.6
2023-04-03 00:00:00 | CHC | 5 | 5 | 4 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0.25
2023-04-03 00:00:00 | COL | 3 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2023-04-03 00:00:00 | PIT | 4 | 4 | 4 | 1 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0.25
2023-04-03 00:00:00 | DET | 7 | 7 | 7 | 4 | 4 | 0 | 0 | 0 | 2 | 2 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0.57142857
2023-04-03 00:00:00 | SFG | 7 | 7 | 5 | 2 | 1 | 0 | 0 | 1 | 2 | 2 | 2 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0.4
2023-04-03 00:00:00 | LAA | 6 | 6 | 6 | 3 | 2 | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0.5
2023-04-03 00:00:00 | PHI | 5 | 5 | 5 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0.4
2023-04-03 00:00:00 | BAL | 3 | 3 | 3 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0.33333333
2023-04-03 00:00:00 | NYM | 3 | 3 | 3 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.33333333
2023-04-02 00:00:00 | LAA | 3 | 3 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0
2023-04-02 00:00:00 | BAL | 5 | 5 | 4 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0.25
2023-04-02 00:00:00 | PHI | 4 | 4 | 3 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0.33333333
2023-04-02 00:00:00 | MIN | 7 | 7 | 6 | 3 | 3 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0.5
2023-04-02 00:00:00 | DET | 4 | 4 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2023-04-02 00:00:00 | MIL | 6 | 6 | 5 | 2 | 1 | 1 | 0 | 0 | 1 | 1 | 1 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0.4
2023-04-02 00:00:00 | ATL | 3 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2023-04-02 00:00:00 | COL | 3 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2023-04-02 00:00:00 | NYM | 3 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2023-04-02 00:00:00 | CLE | 7 | 7 | 5 | 2 | 1 | 0 | 0 | 1 | 3 | 3 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.4
2023-04-02 00:00:00 | PIT | 3 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2023-04-02 00:00:00 | TOR | 7 | 7 | 5 | 3 | 2 | 1 | 0 | 0 | 3 | 3 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0.6
2023-04-02 00:00:00 | ARI | 3 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2023-04-02 00:00:00 | SFG | 3 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2023-04-02 00:00:00 | CHW | 6 | 6 | 5 | 2 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 0.4
2023-04-01 00:00:00 | COL | 5 | 5 | 4 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0.25
2023-04-01 00:00:00 | ATL | 3 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2023-04-01 00:00:00 | BAL | 5 | 5 | 4 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 2 | 0 | 0 | 0 | 0 | 2 | 0 | 0.25
2023-04-01 00:00:00 | CHW | 4 | 4 | 4 | 1 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.25
2023-04-01 00:00:00 | PHI | 3 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2023-04-01 00:00:00 | PIT | 4 | 4 | 4 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0.25
2023-04-01 00:00:00 | MIN | 3 | 3 | 3 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0.33333333
2023-04-01 00:00:00 | CLE | 4 | 4 | 4 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0.25
2023-04-01 00:00:00 | LAA | 3 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2023-04-01 00:00:00 | DET | 5 | 5 | 5 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0.2
2023-04-01 00:00:00 | MIL | 3 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2023-04-01 00:00:00 | ARI | 4 | 4 | 4 | 1 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0.25
2023-04-01 00:00:00 | SFG | 5 | 5 | 5 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0.4
2023-04-01 00:00:00 | NYM | 5 | 5 | 3 | 1 | 0 | 1 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0.33333333
2023-04-01 00:00:00 | TOR | 4 | 4 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0
2023-03-31 00:00:00 | NYM | 3 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2023-03-31 00:00:00 | ARI | 4 | 4 | 4 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0.25
2023-03-31 00:00:00 | CLE | 6 | 6 | 4 | 2 | 2 | 0 | 0 | 0 | 3 | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0.5
2023-03-31 00:00:00 | COL | 3 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2023-03-31 00:00:00 | CHW | 3 | 3 | 3 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0.33333333
2023-03-30 00:00:00 | PIT | 4 | 4 | 4 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0.25
2023-03-30 00:00:00 | CHW | 3 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2023-03-30 00:00:00 | MIL | 3 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2023-03-30 00:00:00 | CLE | 3 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2023-03-30 00:00:00 | MIN | 3 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0
2023-03-30 00:00:00 | NYM | 3 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2023-03-30 00:00:00 | BAL | 3 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2023-03-30 00:00:00 | PHI | 5 | 5 | 5 | 2 | 0 | 1 | 0 | 1 | 2 | 2 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0.4
2023-03-30 00:00:00 | TOR | 6 | 6 | 5 | 2 | 1 | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0.4
2023-03-30 00:00:00 | SFG | 4 | 4 | 4 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 0 | 0 | 0 | 1 | 0 | 0.25
2023-03-30 00:00:00 | ARI | 4 | 4 | 3 | 1 | 0 | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0.33333333
2023-03-30 00:00:00 | COL | 4 | 4 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2023-03-30 00:00:00 | ATL | 9 | 9 | 8 | 4 | 4 | 0 | 0 | 0 | 3 | 3 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0.5
2023-03-30 00:00:00 | LAA | 3 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2023-03-30 00:00:00 | DET | 4 | 4 | 4 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0.25