My suggestion still works. I dont see how you expect to get an answer of 6 for those red cells when you only have 4 matching entries in that row?

E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
18
 Tier 1 Tier 2 Tier 3 Tier 4 Tier 5 Tier 6
set 1
set 2
set 3
Total sets
Count to Next Set
19
1
1
1
1
1
1
1
0
0
1
6
6
 Correct
20
1
1
1
1
2
0
1
0
0
1
4
4
 incorrect
21
1
1
1
1
0
2
1
0
0
1
4
4
 incorrect
22
2
2
2
2
2
2
0
2
0
2
6
6
 correct
23
2
2
2
2
3
1
0
2
0
2
4
4
 incorrect
24
2
2
2
2
1
3
0
2
0
2
4
4
 incorrect
25
2
2
2
2
4
0
0
2
0
2
4
4
 incorrect
26
2
2
2
2
0
4
0
2
0
2
4
4
 incorrect

Q19=COUNTIF(E19:J19,P19)