Stephen_IV
Well-known Member
- Joined
- Mar 17, 2003
- Messages
- 1,168
- Office Version
- 365
- 2019
- Platform
- Windows
I know how to use Countifs but I decided to try to use the Filter function and cannot understand why I keeps giving me a count of 1 for 2 of the values that should be 0 (I suppose CountA).
For in stance HOU gives me a count of ($A$1:$A$28=$D14)*($B$1:$B$28="W") {0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0} and I am still receiving a count of 1. Any help I would appreciate it!
For in stance HOU gives me a count of ($A$1:$A$28=$D14)*($B$1:$B$28="W") {0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0;0} and I am still receiving a count of 1. Any help I would appreciate it!
Breaking Down Series.xlsx | |||||||||
---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | |||
1 | BOS | W | Team | Filter | Countifs | ||||
2 | TOR | T | BOS | 1 | 1 | ||||
3 | BAL | L | TOR | 3 | 3 | ||||
4 | DET | W | BAL | 3 | 3 | ||||
5 | CLE | W | DET | 2 | 2 | ||||
6 | BAL | W | CLE | 2 | 2 | ||||
7 | KCR | W | KCR | 1 | 1 | ||||
8 | TOR | W | TEX | 1 | 1 | ||||
9 | TEX | W | CHW | 1 | 1 | ||||
10 | TOR | W | TBR | 2 | 2 | ||||
11 | CHW | W | LAA | 1 | 1 | ||||
12 | BAL | W | MIN | 1 | 1 | ||||
13 | CHW | L | CHC | 1 | 1 | ||||
14 | BAL | W | HOU | 1 | 0 | ||||
15 | TBR | T | OAK | 1 | 1 | ||||
16 | LAA | W | PIT | 1 | 0 | ||||
17 | DET | W | |||||||
18 | MIN | W | |||||||
19 | CHC | W | |||||||
20 | TBR | W | |||||||
21 | TOR | W | |||||||
22 | TBR | W | |||||||
23 | HOU | T | |||||||
24 | OAK | W | |||||||
25 | HOU | L | |||||||
26 | CLE | W | |||||||
27 | PIT | T | |||||||
28 | BOS | T | |||||||
Sheet2 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
E2:E16 | E2 | =COUNTA(FILTER($A$1:$A$28,($A$1:$A$28=$D2)*($B$1:$B$28="W"))) |
G2:G16 | G2 | =COUNTIFS($A$1:$A$28,D2,$B$1:$B$28,"W") |