Spreadsheet: 827525d1682782548-help-with-average-if-help-with-average-if
Sheet: Sheet1 (2)

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Help with AVERAGE IF
2022 Season |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Runs For | Runs Against | Run Margin | Site | Opponent | Starting Pitcher | h | a | h+a |  |  | Last 10 Games | Last 5 Games | Last 3 Games
1 | 3 | -2 | h | Astros | [NAME] |  |  |  |  | Starter | 10 | 5 | 3
2 | 0 | 2 | h | Astros | [NAME]
1 | 4 | -3 | h | Astros | [NAME]
6 | 2 | 4 | h | [NAME] | [NAME]
4 | 3 | 1 | h | [NAME] | [NAME] |  |  |  |  |  | Last 10 Games @ Home | Last 10 Games @ Away
5 | 10 | -5 | a | Rangers | [NAME]
9 | 6 | 3 | a | Rangers | Reid Detmers
7 | 2 | 5 | a | Rangers | [NAME]
8 | 3 | 5 | a | Rangers | [NAME]
3 | 8 | -5 | a | Astros | [NAME]
7 | 2 | 5 | a | Astros | [NAME]
6 | 0 | 6 | a | Astros | [NAME]
3 | 5 | -2 | h | Orioles | Reid Detmers
4 | 5 | -1 | h | Orioles | [NAME]
7 | 6 | 1 | h | Orioles | [NAME]
3 | 0 | 3 | h | Guardians | [NAME]
4 | 1 | 3 | h | Guardians | [NAME]
9 | 5 | 4 | h | Guardians | [NAME]
4 | 1 | 3 | h | Guardians | Reid Detmers
5 | 1 | 4 | a | White Sox | [NAME]
0 | 4 | -4 | a | White Sox | [NAME]
6 | 5 | 1 | a | White Sox | [NAME]
0 | 3 | -3 | a | White Sox | [NAME]
0 | 4 | -4 | a | Red Sox | [NAME]
10 | 5 | 5 | a | Red Sox | Reid Detmers
8 | 0 | 8 | a | Red Sox | [NAME]
3 | 0 | 3 | h | Nationals | [NAME]
3 | 7 | -4 | h | Nationals | [NAME]
5 | 4 | 1 | h | Nationals | [NAME]
11 | 3 | 8 | h | Rays | [NAME]
12 | 0 | 12 | h | Rays | Reid Detmers
2 | 4 | -2 | h | Rays | [NAME]
2 | 0 | 2 | a | Athletics | Chase Silseth
3 | 4 | -1 | a | Athletics | [NAME]
9 | 1 | 8 | a | Athletics | [NAME]
4 | 1 | 3 | a | Athletics | [NAME]
4 | 7 | -3 | a | Rangers | [NAME]
5 | 10 | -5 | a | Rangers | Reid Detmers
5 | 6 | -1 | a | Rangers | [NAME]
2 | 4 | -2 | h | Athletics | Chase Silseth
5 | 3 | 2 | h | Athletics | [NAME]
4 | 1 | 3 | h | Athletics | [NAME]
5 | 3 | 2 | h | Rangers | [NAME]
2 | 7 | -5 | h | Rangers | Reid Detmers
3 | 6 | -3 | h | Blue Jays | [NAME]
3 | 4 | -1 | h | Blue Jays | Chase Silseth
5 | 6 | -1 | h | Blue Jays | [NAME]
10 | 11 | -1 | h | Blue Jays | [NAME]
1 | 9 | -8 | a | Yankees | [NAME]
1 | 6 | -5 | a | Yankees | [NAME]
1 | 2 | -1 | a | Yankees | Reid Detmers
0 | 10 | -10 | a | Phillies | Chase Silseth
2 | 7 | -5 | a | Phillies | [NAME]
7 | 9 | -2 | a | Phillies | [NAME]
0 | 1 | -1 | h | Red Sox | [NAME]
5 | 6 | -1 | h | Red Sox | [NAME]
0 | 1 | -1 | h | Red Sox | Reid Detmers
5 | 2 | 3 | h | Red Sox | [NAME]
3 | 7 | -4 | h | Mets | [NAME]
11 | 6 | 5 | h | Mets | [NAME]
1 | 4 | -3 | h | Mets | [NAME]
0 | 2 | -2 | a | Dodgers | [NAME]
1 | 4 | -3 | a | Dodgers | Reid Detmers
4 | 1 | 3 | a | Mariners | [NAME]
1 | 8 | -7 | a | Mariners | [NAME]
4 | 2 | 2 | a | Mariners | [NAME]
3 | 0 | 3 | a | Mariners | [NAME]
4 | 0 | 4 | a | Mariners | [NAME]
2 | 6 | -4 | h | Royals | [NAME]
11 | 12 | -1 | h | Royals | Reid Detmers
5 | 0 | 5 | h | Royals | [NAME]
3 | 4 | -1 | h | Mariners | [NAME]
3 | 5 | -2 | h | Mariners | [NAME]
2 | 1 | 1 | h | Mariners | [NAME]
4 | 3 | 1 | h | White Sox | [NAME]
4 | 11 | -7 | h | White Sox | Chase Silseth
4 | 1 | 3 | h | White Sox | [NAME]
1 | 8 | -7 | a | Astros | [NAME]
1 | 9 | -8 | a | Astros | [NAME]
2 | 4 | -2 | a | Astros | [NAME]
1 | 2 | -1 | a | [NAME] | [NAME]
5 | 2 | 3 | a | [NAME] | [NAME]
1 | 4 | -3 | a | Orioles | Chase Silseth
4 | 5 | -1 | a | Orioles | Reid Detmers
0 | 1 | -1 | a | Orioles | [NAME]
5 | 9 | -4 | a | Orioles | [NAME]
5 | 6 | -1 | h | Astros | [NAME]
7 | 1 | 6 | h | Astros | [NAME]
2 | 3 | -1 | h | Astros | Reid Detmers
1 | 9 | -8 | h | Dodgers | [NAME]
1 | 7 | -6 | h | Dodgers | [NAME]
1 | 8 | -7 | a | Braves | [NAME]
2 | 7 | -5 | a | Braves | [NAME]
9 | 1 | 8 | a | Braves | Reid Detmers
0 | 7 | -7 | a | Royals | [NAME]
6 | 0 | 6 | a | Royals | [NAME]
4 | 0 | 4 | a | Royals | [NAME]
0 | 2 | -2 | h | Rangers | [NAME]
2 | 7 | -5 | h | Rangers | [NAME]
9 | 7 | 2 | h | Rangers | Chase Silseth
2 | 5 | -3 | h | Rangers | Reid Detmers
3 | 1 | 2 | h | Athletics | [NAME]
1 | 3 | -2 | h | Athletics | [NAME]
7 | 8 | -1 | h | Athletics | [NAME]
4 | 3 | 1 | a | Mariners | [NAME]
1 | 2 | -1 | a | Mariners | [NAME]
7 | 1 | 6 | a | Mariners | Reid Detmers
3 | 6 | -3 | a | Mariners | [NAME]
1 | 0 | 1 | a | Athletics | [NAME]
5 | 1 | 4 | a | Athletics | [NAME]
5 | 4 | 1 | a | Athletics | [NAME]
0 | 4 | -4 | h | Twins | [NAME]
5 | 3 | 2 | h | Twins | Reid Detmers
4 | 2 | 2 | h | Twins | [NAME]
2 | 6 | -4 | h | Mariners | [NAME]
2 | 8 | -6 | h | Mariners | [NAME]
7 | 11 | -4 | h | Mariners | [NAME]
1 | 0 | 1 | a | Tigers | [NAME]
3 | 4 | -1 | a | Tigers | Reid Detmers
0 | 4 | -4 | a | Tigers | [NAME]
1 | 2 | -1 | a | Rays | [NAME]
1 | 11 | -10 | a | Rays | [NAME]
3 | 4 | -1 | a | Rays | [NAME]
3 | 8 | -5 | a | Rays | [NAME]
12 | 0 | 12 | a | Blue Jays | Reid Detmers
2 | 0 | 2 | a | Blue Jays | [NAME]
8 | 3 | 5 | a | Blue Jays | [NAME]
4 | 3 | 1 | h | Yankees | [NAME]
4 | 7 | -3 | h | Yankees | [NAME]
3 | 2 | 1 | h | Yankees | [NAME]
2 | 4 | -2 | h | Astros | Reid Detmers
2 | 1 | 1 | h | Astros | [NAME]
1 | 9 | -8 | h | Astros | [NAME]
10 | 0 | 10 | h | Tigers | [NAME]
5 | 4 | 1 | h | Tigers | [NAME]
4 | 5 | -1 | h | Tigers | [NAME]
3 | 4 | -1 | a | Astros | [NAME]
6 | 1 | 5 | a | Astros | [NAME]
4 | 12 | -8 | a | Astros | [NAME]
4 | 5 | -1 | a | Guardians | Reid Detmers
1 | 3 | -2 | a | Guardians | [NAME]
3 | 5 | -2 | a | Guardians | [NAME]
8 | 7 | 1 | h | Mariners | [NAME]
2 | 1 | 1 | h | Mariners | [NAME]
5 | 1 | 4 | h | Mariners | Reid Detmers
1 | 9 | -8 | h | Mariners | [NAME]
5 | 2 | 3 | a | Rangers | [NAME]
2 | 7 | -5 | a | Rangers | [NAME]
3 | 5 | -2 | a | Rangers | [NAME]
4 | 2 | 2 | a | Twins | [NAME]
4 | 8 | -4 | a | Twins | Reid Detmers
10 | 3 | 7 | a | Twins | [NAME]
4 | 3 | 1 | h | Athletics | [NAME]
4 | 1 | 3 | h | Athletics | [NAME]
4 | 2 | 2 | h | Athletics | [NAME]
4 | 1 | 3 | h | Rangers | Reid Detmers
3 | 2 | 1 | h | Rangers | [NAME]
8 | 3 | 5 | h | Rangers | [NAME]
4 | 5 | -1 | a | Athletics | [NAME]
1 | 2 | -1 | a | Athletics | [NAME]
2 | 3 | -1 | a | Athletics | [NAME]
2023 Season
Runs For | Runs Against | Run Margin | Site | Opponent | Starting Pitcher
1 | 2 | -1 | a | Athletics | [NAME]
13 | 1 | 12 | a | Athletics | [NAME]
6 | 0 | 6 | a | Athletics | [NAME]
7 | 3 | 4 | a | Mariners | Reid Detmers
2 | 11 | -9 | a | Mariners | [NAME]
4 | 3 | 1 | a | Mariners | [NAME]
3 | 4 | -1 | h | Blue Jays | [NAME]
9 | 5 | 4 | h | Blue Jays | [NAME]
11 | 12 | -1 | h | Blue Jays | Reid Detmers
4 | 6 | -2 | h | Nationals | [NAME]
2 | 0 | 2 | h | Nationals | [NAME]
3 | 2 | 1 | h | Nationals | [NAME]
3 | 5 | -2 | a | Red Sox | [NAME]
7 | 9 | -2 | a | Red Sox | [NAME]
1 | 2 | -1 | a | Red Sox | Reid Detmers
5 | 4 | 1 | a | Red Sox | [NAME]
5 | 2 | 3 | a | Yankees | [NAME]
2 | 3 | -1 | a | Yankees | [NAME]
3 | 9 | -6 | a | Yankees | [NAME]
2 | 0 | 2 | h | Royals | [NAME]
8 | 11 | -3 | h | Royals | [NAME]
4 | 3 | 1 | h | Royals | Reid Detmers
10 | 11 | -1 | h | Athletics | [NAME]
5 | 3 | 2 | h | Athletics | [NAME]