J
Jonathan
Hi all,
I have the data below and want to do the following: In ONE cell, I want
there to be a count of the IDs that have an X in more than one rule. In the
case below, ID 1 would be counted, but ID 2 would not, ID 3 would, etc. Any
help? Thanks!
ID Rule 1 Rule 2 Rule 3 Rule 4 Rule 5
1 X X
2 X
3 X X
4
5 X
6 X
7 X X
8 X
9 X
10 X
11
12
13 X X
14
15 X
16 X
17
18 X
19 X
20 X
21 X
22 X X
23 X X X
I have the data below and want to do the following: In ONE cell, I want
there to be a count of the IDs that have an X in more than one rule. In the
case below, ID 1 would be counted, but ID 2 would not, ID 3 would, etc. Any
help? Thanks!
ID Rule 1 Rule 2 Rule 3 Rule 4 Rule 5
1 X X
2 X
3 X X
4
5 X
6 X
7 X X
8 X
9 X
10 X
11
12
13 X X
14
15 X
16 X
17
18 X
19 X
20 X
21 X
22 X X
23 X X X