Spreadsheet: 265948d1379445530-countifs-if-and-formula-help-mlb-1999
Sheet: temp

 |  |  |  |  |  |  |  |  | STARTING PITCHER | ODDS | W/L | RS | RA | [NAME] | N/D | RD | RT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  | G2 |  |  | G3 |  |  | G4 |  |  | G5 |  |  | TOT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | W | L | W/L | W | L | W/L | W | L | W/L | W | L | W/L | W | L | W/L | W | L | W/L
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | @
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | F
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | @D
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | @F
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HF
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AWAY |  |  | HOME |  |  | TOTAL |  |  |  | T | H | A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | W | L | W/L | W | L | W/L | W | L | W/L | WW
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  | WL |  |  |  |  |  |  |  |  |  | Win >1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | +111 - +120 |  |  |  |  |  |  |  |  |  | LW |  |  |  |  |  |  |  |  |  | TOT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | +121 - +130 |  |  |  |  |  |  |  |  |  | LL |  |  |  |  |  |  |  |  |  | @
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | +131 - +140 |  |  |  |  |  |  |  |  |  | 1-2 |  |  |  |  |  |  |  |  |  | @ DOG
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | +141 - +150 |  |  |  |  |  |  |  |  |  | WW |  |  |  |  |  |  |  |  |  | @ FAV
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | +151 - +160 |  |  |  |  |  |  |  |  |  | WL |  |  |  |  |  |  |  |  |  | H
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | +161 - +170 |  |  |  |  |  |  |  |  |  | LW |  |  |  |  |  |  |  |  |  | H DOG
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | +171 - +180 |  |  |  |  |  |  |  |  |  | LL |  |  |  |  |  |  |  |  |  | H FAV
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | +181 - +190 |  |  |  |  |  |  |  |  |  | 2-3 |  |  |  |  |  |  |  |  |  | DOG
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | +191 - +200 |  |  |  |  |  |  |  |  |  | WWW |  |  |  |  |  |  |  |  |  | FAV
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | > +201 |  |  |  |  |  |  |  |  |  | WWL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AWAY |  |  | HOME |  |  | TOTAL |  |  | WLW
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | W | L | W/L | W | L | W/L | W | L | W/L | WLL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -101 - -110 |  |  |  |  |  |  |  |  |  | LWW
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -111 - -120 |  |  |  |  |  |  |  |  |  | LWL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -121 - -130 |  |  |  |  |  |  |  |  |  | LLW
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -131 - -140 |  |  |  |  |  |  |  |  |  | LLL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -141 - -150 |  |  |  |  |  |  |  |  |  | 1-3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -151 - -160 |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -161 - -170 |  |  |  |  |  |  |  |  |  | WWWL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -171 - -180 |  |  |  |  |  |  |  |  |  | LLLW
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -181 - -190 |  |  |  |  |  |  |  |  |  | LLLL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -191 - -200 |  |  |  |  |  |  |  |  |  | 1-4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | < -201